From a4bac981d4afc703b8751fb11f84882c6b3bdafa Mon Sep 17 00:00:00 2001 From: root Date: Fri, 1 Jun 2018 14:05:42 +0100 Subject: [PATCH] civicrm_relationship table name changed to alias name rel, because its changed in the actual query but not in this extra Where condition --- 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 671953faed..8048c8ff75 100644 --- a/CRM/Case/BAO/Case.php +++ b/CRM/Case/BAO/Case.php @@ -869,7 +869,7 @@ SELECT case_status.label AS case_status, status_id, civicrm_case_type.title AS c ); if ($relationshipID) { - $query .= ' AND civicrm_relationship.id = %3 '; + $query .= ' AND rel.id = %3 '; $params[3] = array($relationshipID, 'Integer'); } $dao = CRM_Core_DAO::executeQuery($query, $params); -- 2.25.1