Multi select contact reference field - Activity Details Report fails with Truncated incorrect INTEGER value
When running the Activity Details report in CiviCRM 5.36.1 with a contact reference field that is multi select.
Seems related to this change: #2123 (closed)
SELECT civicrm_contact_target.sort_name as civicrm_contact_contact_target, civicrm_contact_target.gender_id as civicrm_contact_contact_target_gender, civicrm_contact_target.id as civicrm_contact_contact_target_id, activity_civireport.id as civicrm_activity_id, activity_civireport.source_record_id as civicrm_activity_source_record_id, activity_civireport.activity_type_id as civicrm_activity_activity_type_id, activity_civireport.subject as civicrm_activity_activity_subject, activity_civireport.activity_date_time as civicrm_activity_activity_date_time, activity_civireport.status_id as civicrm_activity_status_id, activity_civireport.duration as civicrm_activity_duration, activity_civireport.details as civicrm_activity_details, activity_civireport.priority_id as civicrm_activity_priority_id, address_civireport.country_id as civicrm_address_country_id, contact_custom_29_civireport.display_name as civicrm_value_phone_call_in_10_custom_29, value_phone_call_in_10_civireport.category_30 as civicrm_value_phone_call_in_10_custom_30, address_civireport.street_name as civicrm_address_street_name, address_civireport.street_number as civicrm_address_street_number, address_civireport.street_address as civicrm_address_street_address, address_civireport.city as civicrm_address_city, address_civireport.postal_code as civicrm_address_postal_code \n
FROM civicrm_activity activity_civireport\n
INNER JOIN civicrm_activity_contact activity_contact_civireport\n
ON activity_civireport.id = activity_contact_civireport.activity_id AND\n
activity_contact_civireport.record_type_id = 3\n
INNER JOIN civicrm_contact civicrm_contact_target\n
ON activity_contact_civireport.contact_id = civicrm_contact_target.id\n
\n
LEFT JOIN civicrm_address address_civireport\n
ON (civicrm_contact_target.id =\n
address_civireport.contact_id) AND\n
address_civireport.is_primary = 1\n
\n
LEFT JOIN civicrm_value_phone_call_in_10 value_phone_call_in_10_civireport ON value_phone_call_in_10_civireport.entity_id = activity_civireport.id\n
LEFT JOIN civicrm_contact contact_custom_29_civireport ON contact_custom_29_civireport.id = value_phone_call_in_10_civireport.referred_to_29 WHERE activity_civireport.is_test = 0 AND\n
activity_civireport.is_deleted = 0 AND\n
activity_civireport.is_current_revision = 1 AND ( activity_civireport.activity_date_time >= 20210801000000) AND ( activity_civireport.activity_date_time <= 20210831235959) AND ( activity_civireport.activity_type_id IN (2) ) [nativecode=1292 ** Truncated incorrect INTEGER value: '\x01730\x01']
"""
4 => "1292 ** Truncated incorrect INTEGER value: '\x01730\x01'"
]