From 9cf08be44e11507addabc090359d8f988cb1e352 Mon Sep 17 00:00:00 2001 From: Tunbola Ogunwande Date: Wed, 18 Mar 2020 16:16:37 +0100 Subject: [PATCH] dev/core#1659: Set the param type for client Id. --- CRM/Case/BAO/Case.php | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) diff --git a/CRM/Case/BAO/Case.php b/CRM/Case/BAO/Case.php index 0d12748dfe..3f0783aee4 100644 --- a/CRM/Case/BAO/Case.php +++ b/CRM/Case/BAO/Case.php @@ -1176,9 +1176,11 @@ SELECT civicrm_case.id, case_status.label AS case_status, status_id, civicrm_cas AND cr.is_active AND cc.id NOT IN (%2) HERESQL; + + $clientIdType = !empty($caseInfo['client_id']) ? 'CommaSeparatedIntegers' : 'String'; $params = [ 1 => [$caseID, 'Integer'], - 2 => [implode(',', $caseInfo['client_id']), 'String'], + 2 => [implode(',', $caseInfo['client_id']), $clientIdType], ]; $dao = CRM_Core_DAO::executeQuery($query, $params); -- 2.25.1