Timeline for Search builder - Cant find find Participants in more than one event
Current License: CC BY-SA 4.0
10 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| May 17, 2020 at 22:42 | comment | added | Robinnz | but OR will give the wrong answer.. I want people who have been to both, not to either? | |
| May 17, 2020 at 12:36 | comment | added | Andy Clark | Or change the search builder so that you are effectively using 'OR'. The way you have it's using 'AND'. So search bulder could certainly do this by using 'also include contacts where' part rather than 'Another search field' | |
| May 16, 2020 at 23:26 | comment | added | Robinnz | ah..great answer, makes perfect sense... thanks very much for your help | |
| May 16, 2020 at 14:27 | comment | added | Demerit |
I'm not sure you can do this this way because a single participant record is never going to match both at the same time, i.e. something like SELECT id FROM civicrm_participant WHERE event_id = 1 AND event_id = 2 is always false. The same way e.g. you wouldn't be able to use this to find people who made contributions of both $100 and $200. As noted you probably need to do something like use groups.
|
|
| May 16, 2020 at 5:48 | comment | added | Robinnz | that will certainly give an answer but as I said I was hoping to avoid this extra step.. everything else works fine in Search Builder - just cant seem to get participants working? | |
| May 16, 2020 at 5:17 | comment | added | petednz - fuzion♦ | create a Group of each sets of Participants and then try using those via Search Builder? | |
| May 16, 2020 at 0:14 | comment | added | Robinnz | screenshot added, thanks | |
| May 16, 2020 at 0:12 | history | edited | Robinnz | CC BY-SA 4.0 |
screenshot
|
| May 15, 2020 at 21:55 | comment | added | Pradeep Nayak | can you share a screenshot of search criteria? | |
| May 15, 2020 at 10:10 | history | asked | Robinnz | CC BY-SA 4.0 |