From 8ed7086511d67d4029079cd60cecb9c1cf03f90d Mon Sep 17 00:00:00 2001 From: larssandergreen Date: Thu, 29 Sep 2022 21:32:35 -0600 Subject: [PATCH] qty > 0 only --- CRM/Event/BAO/Query.php | 1 + 1 file changed, 1 insertion(+) diff --git a/CRM/Event/BAO/Query.php b/CRM/Event/BAO/Query.php index 4b5e7c18f1..f57ce0d7fb 100644 --- a/CRM/Event/BAO/Query.php +++ b/CRM/Event/BAO/Query.php @@ -335,6 +335,7 @@ class CRM_Event_BAO_Query extends CRM_Core_BAO_Query { $labels[] = CRM_Core_DAO::getFieldValue('CRM_Price_DAO_PriceFieldValue', $val, 'label'); } $query->_where[$grouping][] = "civicrm_line_item.price_field_value_id IN (" . implode(', ', $value) . ")"; + $query->_where[$grouping][] = "civicrm_line_item.qty > 0"; $query->_qill[$grouping][] = ts("Fee level") . " IN " . implode(', ', $labels); $query->_tables['civicrm_participant'] = $query->_tables['civicrm_line_item'] = $query->_whereTables['civicrm_line_item'] = 1; return; -- 2.25.1