Details
-
Type: Bug
-
Status: Done/Fixed
-
Priority: Trivial
-
Resolution: Fixed/Completed
-
Affects Version/s: 2.2.7
-
Fix Version/s: 2.2.8
-
Component/s: Core CiviCRM
-
Labels:None
Description
The queries that pull a list of events and profiles should be improved. They currently only filter on whether the profile/event is active. These queries are found in the xml files for each menu option (/site/views/Events/ and /site/views/Profiles/).
Events:
SELECT id, title FROM civicrm_event WHERE is_active=1 AND is_online_registration = 1 ORDER BY title
Profiles:
SELECT DISTINCT
civicrm_uf_group.id,
civicrm_uf_group.group_type,
civicrm_uf_group.title
FROM civicrm_uf_join
INNER JOIN
civicrm_uf_group
ON (civicrm_uf_join.uf_group_id = civicrm_uf_group.id)
WHERE (civicrm_uf_group.is_active = 1)
ORDER BY civicrm_uf_group.title ASC