From c44cb2b88fe8bb190c2f35e941747877126688bd Mon Sep 17 00:00:00 2001 From: Pradeep Nayak Date: Thu, 5 Mar 2020 12:29:27 +0000 Subject: [PATCH] Use dbAlias to generate where clause for date field in activity report --- CRM/Report/Form/Activity.php | 2 +- CRM/Report/Form/ActivitySummary.php | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/CRM/Report/Form/Activity.php b/CRM/Report/Form/Activity.php index fa43ee5f26..fdeb79bef5 100644 --- a/CRM/Report/Form/Activity.php +++ b/CRM/Report/Form/Activity.php @@ -540,7 +540,7 @@ class CRM_Report_Form_Activity extends CRM_Report_Form { $from = CRM_Utils_Array::value("{$fieldName}_from", $this->_params); $to = CRM_Utils_Array::value("{$fieldName}_to", $this->_params); - $clause = $this->dateClause($field['name'], $relative, $from, $to, $field['type']); + $clause = $this->dateClause($field['dbAlias'], $relative, $from, $to, $field['type']); } else { $op = CRM_Utils_Array::value("{$fieldName}_op", $this->_params); diff --git a/CRM/Report/Form/ActivitySummary.php b/CRM/Report/Form/ActivitySummary.php index 14b5946642..e607a8b70f 100644 --- a/CRM/Report/Form/ActivitySummary.php +++ b/CRM/Report/Form/ActivitySummary.php @@ -368,7 +368,7 @@ class CRM_Report_Form_ActivitySummary extends CRM_Report_Form { $from = CRM_Utils_Array::value("{$fieldName}_from", $this->_params); $to = CRM_Utils_Array::value("{$fieldName}_to", $this->_params); - $clause = $this->dateClause($field['name'], $relative, $from, $to, $field['type']); + $clause = $this->dateClause($field['dbAlias'], $relative, $from, $to, $field['type']); } else { $op = CRM_Utils_Array::value("{$fieldName}_op", $this->_params); -- 2.25.1