From 8f219a269d4e1ee23b06b74f0719053902792a7e Mon Sep 17 00:00:00 2001 From: Coleman Watts Date: Tue, 7 Nov 2017 11:25:59 -0500 Subject: [PATCH] CRM-21384 - Don't show deleted contacts in case roles ---------------------------------------- * CRM-21384: Ensure deleted contacts are filtered out of CiviCase https://issues.civicrm.org/jira/browse/CRM-21384 --- 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 fa70ea7b38..c71590c649 100644 --- a/CRM/Case/BAO/Case.php +++ b/CRM/Case/BAO/Case.php @@ -817,7 +817,7 @@ SELECT case_status.label AS case_status, status_id, civicrm_case_type.title AS c LEFT JOIN civicrm_phone ON (civicrm_phone.contact_id = con.id AND civicrm_phone.is_primary = 1) LEFT JOIN civicrm_email ON (civicrm_email.contact_id = con.id AND civicrm_email.is_primary = 1) WHERE (rel.contact_id_a = %1 OR rel.contact_id_b = %1) AND rel.case_id = %2 - AND rel.is_active = 1 AND (rel.end_date IS NULL OR rel.end_date > NOW())'; + AND rel.is_active = 1 AND con.is_deleted = 0 AND (rel.end_date IS NULL OR rel.end_date > NOW())'; $params = array( 1 => array($contactID, 'Positive'), -- 2.25.1