From 8cf4fbdb204719cd91f7c7ca01bb257c76c0754e Mon Sep 17 00:00:00 2001 From: Andrew Hunt Date: Fri, 19 Apr 2019 18:40:16 -0400 Subject: [PATCH] CiviCase: use aliases on all items in case activity query b/c ANY_VALUE --- CRM/Case/BAO/Case.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/CRM/Case/BAO/Case.php b/CRM/Case/BAO/Case.php index 95278d995d..a44bf458eb 100644 --- a/CRM/Case/BAO/Case.php +++ b/CRM/Case/BAO/Case.php @@ -429,10 +429,10 @@ WHERE cc.contact_id = %1 AND civicrm_case_type.name = '{$caseType}'"; 'civicrm_phone.phone as phone', 'civicrm_contact.contact_type as contact_type', 'civicrm_contact.contact_sub_type as contact_sub_type', - 't_act.activity_type_id', + 't_act.activity_type_id as activity_type_id', 'civicrm_case.case_type_id as case_type_id', 'civicrm_case.status_id as case_status_id', - 't_act.status_id', + 't_act.status_id as status_id', 'civicrm_case.start_date as case_start_date', 'case_relation_type.label_b_a as case_role', 't_act.activity_date_time as activity_date_time', -- 2.25.1