From 3912a0afbdc720afa82bb0c7bc6ae18f76360662 Mon Sep 17 00:00:00 2001 From: Edsel Date: Tue, 12 May 2015 12:57:28 +0530 Subject: [PATCH] ICM-13 Added group by contribution ID only --- CRM/Report/Form/Contribute/Lybunt.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/CRM/Report/Form/Contribute/Lybunt.php b/CRM/Report/Form/Contribute/Lybunt.php index ecc162e99b..d0111aea8b 100644 --- a/CRM/Report/Form/Contribute/Lybunt.php +++ b/CRM/Report/Form/Contribute/Lybunt.php @@ -438,7 +438,7 @@ class CRM_Report_Form_Contribute_Lybunt extends CRM_Report_Form { {$this->_where} AND {$this->_aliases['civicrm_contribution']}.financial_type_id IN (" . implode(',' , array_keys($financialTypes)) . ") AND {$this->_aliases['civicrm_line_item']}.financial_type_id IN (" . implode(',' , array_keys($financialTypes)) . ") - {$this->_groupBy}"; + GROUP BY {$this->_aliases['civicrm_contribution']}.id"; CRM_Core_DAO::executeQuery($sql); $this->_from .= " INNER JOIN civicrm_contribution_temp temp ON {$this->_aliases['civicrm_contribution']}.id = temp.id "; -- 2.25.1