From e13b3d8e64bef3e76eee89caeb6b6d57f18fd4e5 Mon Sep 17 00:00:00 2001 From: Rohan Katkar Date: Fri, 19 Dec 2014 16:10:28 +0530 Subject: [PATCH] QA fix for CRM-15694 --- 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 abb93b6daa..cfffbdf24c 100644 --- a/CRM/Report/Form/Activity.php +++ b/CRM/Report/Form/Activity.php @@ -905,7 +905,7 @@ GROUP BY civicrm_activity_id {$this->_having} {$this->_orderBy} {$this->_limit}" } $query = "select " . implode(", ", $ifnulls) . - ", count(*) as ct from civireport_activity_temp_target where civicrm_contact_contact_target_id <> '' group by " . + ", count(DISTINCT civicrm_activity_id) as ct from civireport_activity_temp_target group by " . implode(", ", $sectionAliases); // initialize array of total counts -- 2.25.1