Deleted entity data should not be listed in the report. This was not happening for Case and prospects entities.
Before
Deleted cases were included in the pivot report. Also, cache rebuilding process was failing with fatal error, as client_id was not being resolved correctly to the contact_id, since for the field client_id to be returned, contact_id must be part of return fields.
After
Deleted cases are no longer in either Case or Prospect. Added contact_id to return fields. Changed 'IN' operator on chained API call to contact for '=' operator, since 'IN' is unsupported for CiviCRM version <= v4.7.18.
Overview
Deleted entity data should not be listed in the report. This was not happening for Case and prospects entities.
Before
Deleted cases were included in the pivot report. Also, cache rebuilding process was failing with fatal error, as client_id was not being resolved correctly to the contact_id, since for the field client_id to be returned, contact_id must be part of return fields.
After
Deleted cases are no longer in either Case or Prospect. Added contact_id to return fields. Changed 'IN' operator on chained API call to contact for '=' operator, since 'IN' is unsupported for CiviCRM version <= v4.7.18.