From 4962bc929a10193c05864ca00694875d507d3621 Mon Sep 17 00:00:00 2001 From: Jon goldberg - Linux laptop Date: Sat, 15 Feb 2014 11:02:02 -0500 Subject: [PATCH] CRM-14223 - CiviEvent - don't count test registrations when returning participant counts ---------------------------------------- * CRM-14223: http://issues.civicrm.org/jira/browse/CRM-14223 --- CRM/Event/BAO/Event.php | 1 + 1 file changed, 1 insertion(+) diff --git a/CRM/Event/BAO/Event.php b/CRM/Event/BAO/Event.php index 54da21dd37..53a5a379f8 100644 --- a/CRM/Event/BAO/Event.php +++ b/CRM/Event/BAO/Event.php @@ -1990,6 +1990,7 @@ LEFT JOIN civicrm_line_item lineItem ON ( lineItem.entity_id = participant. AND lineItem.entity_table = 'civicrm_participant' ) LEFT JOIN civicrm_price_field_value value ON ( value.id = lineItem.price_field_value_id AND value.count ) WHERE ( participant.event_id = %1 ) + AND participant.is_test = 0 {$extraWhereClause} GROUP BY participant.event_id"; -- 2.25.1