From 6b576a7c332e71e1167199fd1165a6990331a85d Mon Sep 17 00:00:00 2001 From: Coleman Watts Date: Wed, 1 Nov 2017 17:21:38 -0400 Subject: [PATCH] CRM-21384 - Don't show deleted contacts in case relations --- 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 89c77bd94f..fa70ea7b38 100644 --- a/CRM/Case/BAO/Case.php +++ b/CRM/Case/BAO/Case.php @@ -336,7 +336,7 @@ WHERE civicrm_case.id = %1"; LEFT JOIN civicrm_case_contact ON civicrm_case_contact.contact_id = contact_a.id LEFT JOIN civicrm_email ce ON ( ce.contact_id = contact_a.id AND ce.is_primary = 1) LEFT JOIN civicrm_phone cp ON ( cp.contact_id = contact_a.id AND cp.is_primary = 1) - WHERE civicrm_case_contact.case_id = %1 + WHERE contact_a.is_deleted = 0 AND civicrm_case_contact.case_id = %1 ORDER BY civicrm_case_contact.id"; $dao = CRM_Core_DAO::executeQuery($query, -- 2.25.1