Body: <p>Im trying to find people who have attended all 3 of our last 3 annual fund raising dinners.</p>
  
  <ul>
  <li>search for participants in "dinner 2018" - get results</li>
  <li>search for participants  in "dinner 2019" - get results</li>
  </ul>
  
  <p>Search for participants "dinner 2018" AND "dinner 2019" - get zero  (and that's wrong cause I'm one of many who are showing as having been to both)</p>
  
  <p>The same error occurs using event ID</p>
  
  <p>I cant get the event start date to return sensible answers (not sure whats going on there  tbh)</p>
  
  <p>I know I can get the correct answer using groups but thats adding another step in the process each year and Id rather avoid that</p>
  
  <p>any suggestions please?</p>
  
  <p><a href="https://i.sstatic.net/ekNO3.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/ekNO3.png" alt="enter image description here"></a></p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-05-15T21:55:56.887Z
Comments.Text: can you share a screenshot of search criteria?
Comments.UserDisplayName: Pradeep Nayak
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-05-16T00:14:17.663Z
Comments.Text: screenshot added, thanks
Comments.UserDisplayName: Robinnz
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-05-16T05:17:56.730Z
Comments.Text: create a Group of each sets of Participants and then try using those via Search Builder?
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-05-16T05:48:39.040Z
Comments.Text: 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?
Comments.UserDisplayName: Robinnz
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-05-16T14:27:16.800Z
Comments.Text: 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.
Comments.UserDisplayName: Demerit
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-05-16T23:26:31.043Z
Comments.Text: ah..great answer,  makes perfect sense... thanks very much for your help
Comments.UserDisplayName: Robinnz
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-05-17T12:36:13.693Z
Comments.Text: 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'
Comments.UserDisplayName: Andy Clark
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-05-17T22:42:59.783Z
Comments.Text: but OR will give the wrong answer.. I want people who have been to both, not to either?
Comments.UserDisplayName: Robinnz
Tags: <search-builder><participants>
Title: Search builder - Cant find find Participants in more than one event
ThreadText: # Search builder - Cant find find Participants in more than one event
  
  (Asked by: username_0 on 2020-05-15)
  
  Im trying to find people who have attended all 3 of our last 3 annual fund raising dinners.
  
  * search for participants in "dinner 2018" - get results
  * search for participants in "dinner 2019" - get results
  
  Search for participants "dinner 2018" AND "dinner 2019" - get zero (and that's wrong cause I'm one of many who are showing as having been to both)
  
  The same error occurs using event ID
  
  I cant get the event start date to return sensible answers (not sure whats going on there tbh)
  
  I know I can get the correct answer using groups but thats adding another step in the process each year and Id rather avoid that
  
  any suggestions please?
  
  [![enter image description here](https://i.sstatic.net/ekNO3.png)](https://i.sstatic.net/ekNO3.png)
  
  **Tags:** search-builder, participants
  
  > **Comments:**
  > **username_1**: can you share a screenshot of search criteria?  
  > **username_0**: screenshot added, thanks  
  > **username_2**: create a Group of each sets of Participants and then try using those via Search Builder?  
  > **username_0**: 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?  
  > **username_3**: 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.  
  > **username_0**: ah..great answer,  makes perfect sense... thanks very much for your help  
  > **username_4**: 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'  
  > **username_0**: but OR will give the wrong answer.. I want people who have been to both, not to either?  
  
  ---
  
  ## 0 answers
  
  