From 6550b1535028b129fe3c6b8fb75913e9354e58eb Mon Sep 17 00:00:00 2001 From: jitendrapurohit Date: Tue, 23 Jun 2015 18:34:02 +0530 Subject: [PATCH] minor fix for mode in Search --- CRM/Contact/BAO/Query.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/CRM/Contact/BAO/Query.php b/CRM/Contact/BAO/Query.php index 5c5a990f3f..a418fe6321 100644 --- a/CRM/Contact/BAO/Query.php +++ b/CRM/Contact/BAO/Query.php @@ -4781,7 +4781,7 @@ SELECT COUNT( conts.total_amount ) as total_count, } $orderBy = 'ORDER BY civicrm_contribution_total_amount_count DESC'; - $groupBy = 'GROUP BY civicrm_contribution.total_amount'; + $groupBy = 'GROUP BY currency, civicrm_contribution.total_amount'; $modeSQL = "$select, conts.civicrm_contribution_total_amount_count as civicrm_contribution_total_amount_count FROM ($innerQuery $groupBy $orderBy) as conts GROUP BY currency"; -- 2.25.1