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
Attachments
Activity
These are all just related to the Joomla menu item creation mechanism. The Joomla package has the following folders:
com_civicrm/site/views/Contributions/tmpl/
com_civicrm/site/views/Dashboard/tmpl/
com_civicrm/site/views/Events/tmpl/
com_civicrm/site/views/Profiles/tmpl/
Each folder contains a set of xml files and php files for each available Civi menu option. The xml file controls the options available to a user when they are creating a Joomla menu item, which for events and profiles (and contribs) includes a query to populate the dropdown select box. Those queries are not accurate. For Events, it pulls all active events, when it should pull all active events that are enabled for online registration. For Profiles, it pulls all active profiles, when it should also restrict to those profiles that have the "profile" checkbox enabled, indicating it could be available for frontend use.
So these queries fix those.
Brian - Can you clarify and explain the filtering you'd like to see. I'm "assuming" the first query (above) is specifically a "change" for Event Registration (as opposed to Event Info page) menu links - adding is_online_registration = 1. Not sure which type of Profile link you're referencing the 2nd query and what you're trying to do ??