Answers.Body: <p>You have made Join as 'With(optional)' and with status empty will give you contacts who never had membership</p>
  <p>If you do OR clause then you should get 378+40 results approx with group by</p>
  <p><a href="https://i.sstatic.net/52wYc.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/52wYc.png" alt="enter image description here" /></a></p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2024-03-26T12:30:37.873Z
Answers.Text: Many thanks Pradeep!
Answers.UserDisplayName: Mike Wilson
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2024-03-26T13:02:58.550Z
Answers.Text: You can also change the join from "With" to "Without"!
Answers.UserDisplayName: Coleman
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2024-03-26T11:37:22.390Z
Answers.LastActivityDate: 2024-03-26T11:43:18.707Z
Answers.LastEditDate: 2024-03-26T11:43:18.707Z
Answers.UserDisplayName: Pradeep Nayak
Body: <p>Hopefully very easy but I want to build a search kit of people in a mailing group (Historic Event Attendees) who are NOT current members.</p>
  <p>When I do Status = Empty, I get 378,</p>
  <p>but when I do Status = Does not Include New, Current, Renewal, Grace, I only get 40!</p>
  <p>Please can you suggest what extra query I need to add to get this to show me people in the group who are NOT current members, as I should get more in the second query, as that would include those with status lapsed and cancelled.</p>
  <p><a href="https://i.sstatic.net/aw4EG.jpg" rel="nofollow noreferrer"><img src="https://i.sstatic.net/aw4EG.jpg" alt="Search Filter" /></a></p>
  <p>Thanks</p>
  
Tags: <searchkit>
Title: Help with Searchkit query on Non members
ThreadText: # Help with Searchkit query on Non members
  
  (Asked by: username_0 on 2024-03-26)
  
  Hopefully very easy but I want to build a search kit of people in a mailing group (Historic Event Attendees) who are NOT current members.
  
  When I do Status = Empty, I get 378,
  
  but when I do Status = Does not Include New, Current, Renewal, Grace, I only get 40!
  
  Please can you suggest what extra query I need to add to get this to show me people in the group who are NOT current members, as I should get more in the second query, as that would include those with status lapsed and cancelled.
  
  [![Search Filter](https://i.sstatic.net/aw4EG.jpg)](https://i.sstatic.net/aw4EG.jpg)
  
  Thanks
  
  **Tags:** searchkit
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2024-03-26. Score: 0
  
  You have made Join as 'With(optional)' and with status empty will give you contacts who never had membership
  
  If you do OR clause then you should get 378+40 results approx with group by
  
  [![enter image description here](https://i.sstatic.net/52wYc.png)](https://i.sstatic.net/52wYc.png)
  
  > **Comments:**
  > **username_0**: Many thanks username_1!  
  > **username_2**: You can also change the join from "With" to "Without"!  
  
  ---
  
  