From fb1927941a92c3b942bbcb872803a064153d115f Mon Sep 17 00:00:00 2001 From: yashodha Date: Tue, 8 Jan 2019 20:04:15 +0530 Subject: [PATCH] (dev/core#649) DB error on Find Activities with follow up criteria --- CRM/Activity/BAO/Query.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/CRM/Activity/BAO/Query.php b/CRM/Activity/BAO/Query.php index 2a5bdcb30b..1bba431fa2 100644 --- a/CRM/Activity/BAO/Query.php +++ b/CRM/Activity/BAO/Query.php @@ -335,11 +335,11 @@ class CRM_Activity_BAO_Query { case 'parent_id': if ($value == 1) { - $query->_where[$grouping][] = "parent_id.parent_id IS NOT NULL"; + $query->_where[$grouping][] = "civicrm_activity.parent_id IS NOT NULL"; $query->_qill[$grouping][] = ts('Activities which have Followup Activities'); } elseif ($value == 2) { - $query->_where[$grouping][] = "parent_id.parent_id IS NULL"; + $query->_where[$grouping][] = "civicrm_activity.parent_id IS NULL"; $query->_qill[$grouping][] = ts('Activities without Followup Activities'); } break; -- 2.25.1