From f1339cf223eb77638a96a4920131318aba435af5 Mon Sep 17 00:00:00 2001 From: yashodha Date: Tue, 7 Jun 2016 15:26:48 +0530 Subject: [PATCH] CRM-18554: Using IS EMPTY operator for some date fields crashes 4.7.7 ---------------------------------------- * CRM-18554: Using IS EMPTY operator for some date fields crashes 4.7.7 https://issues.civicrm.org/jira/browse/CRM-18554 --- CRM/Contact/BAO/Query.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/CRM/Contact/BAO/Query.php b/CRM/Contact/BAO/Query.php index 91cfb0f614..561ae08e24 100644 --- a/CRM/Contact/BAO/Query.php +++ b/CRM/Contact/BAO/Query.php @@ -5085,7 +5085,7 @@ SELECT COUNT( conts.total_amount ) as cancel_count, } if ($date) { - $this->_where[$grouping][] = self::buildClause("{$tableName}.{$dbFieldName}", $op, $date); + $this->_where[$grouping][] = "{$tableName}.{$dbFieldName} $op $date"; } else { $this->_where[$grouping][] = self::buildClause("{$tableName}.{$dbFieldName}", $op); -- 2.25.1