From 85bdc94e3a8727d782606ebaa59565328bad29c3 Mon Sep 17 00:00:00 2001 From: monishdeb Date: Thu, 1 Aug 2013 15:29:54 +0530 Subject: [PATCH] CRM-13029 fix ---------------------------------------- * CRM-13029: search builder: unable to search activity details http://issues.civicrm.org/jira/browse/CRM-13029 --- CRM/Contact/BAO/Query.php | 2 +- CRM/Utils/Type.php | 1 + 2 files changed, 2 insertions(+), 1 deletion(-) diff --git a/CRM/Contact/BAO/Query.php b/CRM/Contact/BAO/Query.php index e57b2a8eab..c7c2dbf84a 100644 --- a/CRM/Contact/BAO/Query.php +++ b/CRM/Contact/BAO/Query.php @@ -4704,7 +4704,7 @@ SELECT COUNT( civicrm_contribution.total_amount ) as cancel_count, $value = CRM_Utils_Type::escape($value, $dataType); // if we dont have a dataType we should assume - if ($dataType == 'String') { + if ($dataType == 'String' || $dataType == 'Text') { $value = "'" . strtolower($value) . "'"; } return "$clause $value"; diff --git a/CRM/Utils/Type.php b/CRM/Utils/Type.php index eb5fe6ded9..ed22fe2521 100644 --- a/CRM/Utils/Type.php +++ b/CRM/Utils/Type.php @@ -190,6 +190,7 @@ class CRM_Utils_Type { case 'String': case 'Memo': + case 'Text': return CRM_Core_DAO::escapeString($data); case 'Date': -- 2.25.1