From 49344e3fcef9236f9f40ba346bad752c9daeaa23 Mon Sep 17 00:00:00 2001 From: Edsel Date: Wed, 1 Mar 2017 17:34:20 +0530 Subject: [PATCH] CRM-20169 Bug fixes ---------------------------------------- * CRM-20169: Add support for alterReportVar hook in Activity Report https://issues.civicrm.org/jira/browse/CRM-20169 --- CRM/Report/Form/Activity.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/CRM/Report/Form/Activity.php b/CRM/Report/Form/Activity.php index 63e1698038..3adeec00aa 100644 --- a/CRM/Report/Form/Activity.php +++ b/CRM/Report/Form/Activity.php @@ -872,7 +872,7 @@ GROUP BY civicrm_activity_id $having {$this->_orderBy}"; INNER JOIN civicrm_activity_contact {$this->_aliases['civicrm_activity_contact']} ON {$this->_aliases['civicrm_activity_contact']}.activity_id = {$this->_aliases['civicrm_activity']}.id AND {$this->_aliases['civicrm_activity_contact']}.record_type_id = {$sourceID} LEFT JOIN civicrm_contact contact_civireport ON contact_civireport.id = {$this->_aliases['civicrm_activity_contact']}.contact_id - WHERE {$this->_aclWhere} {$groupByFromSelect} {$this->_having} {$this->_orderBy} {$this->_limit}"; + WHERE (1) AND {$this->_aclWhere} {$groupByFromSelect} {$this->_having} {$this->_orderBy} {$this->_limit}"; $this->buildRows($sql, $rows); -- 2.25.1