From 7f3c40d8c511e8f23b83de086e5ff19e41244386 Mon Sep 17 00:00:00 2001 From: Sudha Bisht Date: Tue, 30 Jun 2015 16:32:50 +0530 Subject: [PATCH] Fix for displaying primary id on print case report --- 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 9166a1cd16..1c5c8db679 100644 --- a/CRM/Case/BAO/Case.php +++ b/CRM/Case/BAO/Case.php @@ -984,7 +984,7 @@ SELECT case_status.label AS case_status, status_id, civicrm_case_type.title AS c INNER JOIN civicrm_relationship_type ON civicrm_relationship.relationship_type_id = civicrm_relationship_type.id INNER JOIN civicrm_contact ON civicrm_relationship.contact_id_b = civicrm_contact.id LEFT JOIN civicrm_phone ON (civicrm_phone.contact_id = civicrm_contact.id AND civicrm_phone.is_primary = 1) - LEFT JOIN civicrm_email ON (civicrm_email.contact_id = civicrm_contact.id ) + LEFT JOIN civicrm_email ON (civicrm_email.contact_id = civicrm_contact.id AND civicrm_email.is_primary = 1) WHERE civicrm_relationship.contact_id_a = %1 AND civicrm_relationship.case_id = %2'; $params = array( -- 2.25.1