X-Git-Url: https://vcs.fsf.org/?a=blobdiff_plain;f=CRM%2FReport%2FForm%2FEvent%2FParticipantListCount.php;h=e6adfd7769778f2d2049fa718db0e0e30e8ad99f;hb=d1641c514cc7490923db5111f24c7f98da6fa91e;hp=390e50a66c1cc09b534a262e7b4d13432441d50d;hpb=d8333f0eae010d786319ca3d1fac3993642238b5;p=civicrm-core.git diff --git a/CRM/Report/Form/Event/ParticipantListCount.php b/CRM/Report/Form/Event/ParticipantListCount.php index 390e50a66c..e6adfd7769 100644 --- a/CRM/Report/Form/Event/ParticipantListCount.php +++ b/CRM/Report/Form/Event/ParticipantListCount.php @@ -425,6 +425,7 @@ class CRM_Report_Form_Event_ParticipantListCount extends CRM_Report_Form_Event { $this->_columnHeaders["blank_{$i}"]['title'] = "_ _ _ _"; } } + $this->_selectClauses = $select; $this->_select = "SELECT " . implode(', ', $select) . " "; } @@ -475,6 +476,7 @@ class CRM_Report_Form_Event_ParticipantListCount extends CRM_Report_Form_Event { parent::groupBy(); if (empty($this->_groupBy)) { $this->_groupBy = "GROUP BY {$this->_aliases['civicrm_participant']}.id"; + $this->_groupBy .= CRM_Contact_BAO_Query::getGroupByFromSelectColumns($this->_selectClauses, "{$this->_aliases['civicrm_participant']}.id"); } }