From c2c374976647c888ec53a54ce86218b26fd5d5dc Mon Sep 17 00:00:00 2001 From: Coleman Watts Date: Mon, 20 Mar 2017 21:43:24 -0400 Subject: [PATCH] CRM-20102 - Fix case role lookup by name instead of label --- 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 de60d0c338..e76b348cd3 100644 --- a/CRM/Case/BAO/Case.php +++ b/CRM/Case/BAO/Case.php @@ -1225,7 +1225,7 @@ SELECT case_status.label AS case_status, status_id, civicrm_case_type.title AS c } $values = array(); $query = ' - SELECT cc.display_name as name, cc.sort_name as sort_name, cc.id, cr.relationship_type_id, crt.label_b_a as role, ce.email + SELECT cc.display_name as name, cc.sort_name as sort_name, cc.id, cr.relationship_type_id, crt.label_b_a as role, crt.name_b_a, ce.email FROM civicrm_relationship cr LEFT JOIN civicrm_relationship_type crt ON crt.id = cr.relationship_type_id @@ -1253,7 +1253,7 @@ SELECT case_status.label AS case_status, status_id, civicrm_case_type.title AS c 'email' => $dao->email, ); // Add more info about the role (creator, manager) - $role = CRM_Utils_Array::value($details['role'], $caseRoles); + $role = CRM_Utils_Array::value($dao->name_b_a, $caseRoles); if ($role) { unset($role['name']); $details += $role; -- 2.25.1