From 0a0cc1a61988c5c0d46f34363d806864f416f013 Mon Sep 17 00:00:00 2001 From: jitendrapurohit Date: Wed, 10 Feb 2016 15:43:11 +0530 Subject: [PATCH] add comment --- CRM/Report/Form/Event/ParticipantListing.php | 2 ++ 1 file changed, 2 insertions(+) diff --git a/CRM/Report/Form/Event/ParticipantListing.php b/CRM/Report/Form/Event/ParticipantListing.php index c296bd3e8a..5fcf66c1e4 100644 --- a/CRM/Report/Form/Event/ParticipantListing.php +++ b/CRM/Report/Form/Event/ParticipantListing.php @@ -461,6 +461,8 @@ ORDER BY cv.label } if ($fieldName == 'total_paid' || $fieldName == 'balance') { $this->_balance = TRUE; + // modify the select if filtered by fee_level as the from clause + // already selects the total_amount from civicrm_contribution table if (!empty($this->_params['price_field_value_id_value'])) { $field['dbAlias'] = str_replace('SUM(ft.total_amount)', 'ft.total_amount', $field['dbAlias']); } -- 2.25.1