I want to see who is registered for both of two events. How can I do that as a search or a report?
Advanced Search, Participant Search And reports only allows you to select 'One of' the selected option i.e it does "Event 1 OR Event 2" on the selected events.
But I guess you want "Event 1 AND Event 2", if so you can use CiviCRM >> Search >> Search Builder to do AND between conditions. See below attached image
Cheers
Pradeep
-
Although it's a minor hassle to figure out the IDs of the events, it works. Thanks. – thoni56 Jun 12 at 18:11
-
Unfortunately its a core bug, it should show drop down list with event. – Pradeep Nayak Jun 12 at 18:30
-
Hmm, I'm not sure this always works. I have an Individual that I know is a participant of two events, but with different roles, but the above search does not return this individual. – thoni56 Jun 13 at 17:40
You could do it in multiple steps:
- search for Event 1 participants then create a group
- use advanced search, enter the new group in the group box, and in the events section select Event 2 participants
You could create both of those as smart groups if you want to check progress as registrations come in.
But hopefully someone has a more streamlined method!