From aee55e82aa52fdda5b4a53574f0a29cad421dcff Mon Sep 17 00:00:00 2001 From: Justin Freeman Date: Tue, 6 Nov 2018 14:12:23 +1100 Subject: [PATCH] Adjust brackets to fix logic for civicrm_relationship.is_active --- CRM/Case/BAO/Case.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/CRM/Case/BAO/Case.php b/CRM/Case/BAO/Case.php index a0d9a5704e..8c56360764 100644 --- a/CRM/Case/BAO/Case.php +++ b/CRM/Case/BAO/Case.php @@ -808,7 +808,7 @@ SELECT case_status.label AS case_status, status_id, civicrm_case_type.title AS c LEFT JOIN civicrm_option_value case_status ON ( civicrm_case.status_id = case_status.value AND option_group_case_status.id = case_status.option_group_id ) LEFT JOIN civicrm_relationship case_relationship ON ( case_relationship.case_id = civicrm_case.id - AND case_relationship.contact_id_b = {$userID}) AND case_relationship.is_active + AND case_relationship.contact_id_b = {$userID} AND case_relationship.is_active ) WHERE is_deleted = 0 AND cc.contact_id IN (SELECT id FROM civicrm_contact WHERE is_deleted <> 1) {$myCaseWhereClause} {$myGroupByClause}"; -- 2.25.1