Body: <p>We have a number of participant roles setup in CiviEvent, with IDs ranging from 1-10.  This includes a "Participant" role with ID 1 and "Sponsor" role with ID of 10 (and various roles with IDs 2-9 in between).  The Sponsor role is not counted, all other roles are counted.</p>
  
  <p>When I run a search for contacts with the only criteria being Participant Role = Sponsor, I get the one contact currently assigned to that role.</p>
  
  <p>When I run a search for contacts with the only criteria being Participant Role = Participant, I get all of the contacts assigned to that role, <strong>PLUS</strong> the contact who has the role Sponsor on one event.  </p>
  
  <p>I have triple checked and the "Sponsor" contact only has one event and his only role in that event is Sponsor.  He should not be showing up for the search where the only role selected is Participant.  </p>
  
  <p>The only thing I can think of is that the search criteria is erroneously returning any ID with "1" in it?  </p>
  
  <p>Any other thoughts or ideas?</p>
  
  <hr>
  
  <p>Running on WordPress / CiviCRM 4.6.10</p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-02-17T20:13:09.210Z
Comments.Text: is it the same if you search via Search Builder?
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-02-19T14:33:34.523Z
Comments.Text: Yes, it is.  Very strange.
Comments.UserDisplayName: RobertD
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-10-21T13:51:42.590Z
Comments.Text: We're having the same issue. Did you find a solution?
Comments.UserDisplayName: Heather O.
Tags: <civievent><search><smartgroups><search-results><custom-search>
Title: Advanced Search/Smart Group returning wrong results based on participant role (CiviEvent participant roles overlap?)
ThreadText: # Advanced Search/Smart Group returning wrong results based on participant role (CiviEvent participant roles overlap?)
  
  (Asked by: username_0 on 2016-02-17)
  
  We have a number of participant roles setup in CiviEvent, with IDs ranging from 1-10. This includes a "Participant" role with ID 1 and "Sponsor" role with ID of 10 (and various roles with IDs 2-9 in between). The Sponsor role is not counted, all other roles are counted.
  
  When I run a search for contacts with the only criteria being Participant Role = Sponsor, I get the one contact currently assigned to that role.
  
  When I run a search for contacts with the only criteria being Participant Role = Participant, I get all of the contacts assigned to that role, **PLUS** the contact who has the role Sponsor on one event.
  
  I have triple checked and the "Sponsor" contact only has one event and his only role in that event is Sponsor. He should not be showing up for the search where the only role selected is Participant.
  
  The only thing I can think of is that the search criteria is erroneously returning any ID with "1" in it?
  
  Any other thoughts or ideas?
  
  ---
  
  Running on WordPress / CiviCRM 4.6.10
  
  **Tags:** civievent, search, smartgroups, search-results, custom-search
  
  > **Comments:**
  > **username_1**: is it the same if you search via Search Builder?  
  > **username_0**: Yes, it is.  Very strange.  
  > **username_2**: We're having the same issue. Did you find a solution?  
  
  ---
  
  ## 0 answers
  
  