From b6963180fec0a90e5636e416d14ec427bde0f0b9 Mon Sep 17 00:00:00 2001 From: "deb.monish" Date: Mon, 3 Jul 2017 13:31:17 +0530 Subject: [PATCH] CRM-20640: contribution summary report: duplicates values with group filter --- CRM/Report/Form.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/CRM/Report/Form.php b/CRM/Report/Form.php index 9892c29aa1..409ad8323d 100644 --- a/CRM/Report/Form.php +++ b/CRM/Report/Form.php @@ -3442,7 +3442,7 @@ WHERE cg.extends IN ('" . implode("','", $this->_customGroupExtends) . "') AND $smartGroups = array_keys($groups['values']); $query = " - SELECT group_contact.contact_id as id + SELECT DISTINCT group_contact.contact_id as id FROM civicrm_group_contact group_contact WHERE group_contact.group_id IN (" . implode(', ', $filteredGroups) . ") AND group_contact.status = 'Added' "; -- 2.25.1