Answers.Body: <p>You should be able to do that with SearchKit.  Look for contacts 'with (required)' a non-current membership and 'without' a current membership.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-09-14T19:32:18.993Z
Answers.Text: Thank you - I'm unable to install it - getting an "Entity not loadedGrant" error. We don't use CiviGrant, and I don't feel compelled installing it just to enable SearchKit. I submitted a bug to the SearchKit lab, but it hasn't been accepted yet for some reason. I'll keep trying.
Answers.UserDisplayName: MtnPavlas
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-09-15T08:51:57.120Z
Answers.Text: You don't need CiviGrant enabled for SearchKit but there was a bug in that area when Grants were moved from core to a core extension.  Are you on the latest version?  If not, upgrading may help.
Answers.UserDisplayName: Aidan
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-09-20T03:42:22.117Z
Answers.Text: Thanks again. I'm on CiviCRM 5.52.2, SearchKit 5.52.2
Answers.UserDisplayName: MtnPavlas
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-09-07T21:59:42.977Z
Answers.LastActivityDate: 2022-09-07T21:59:42.977Z
Answers.UserDisplayName: Aidan
Body: <p>When using <em>Advanced Search</em> and <em>'Display Results As'</em> is set to <em>&quot;Contacts&quot;</em>, I assumed that if I selected <em>&quot;No&quot;</em> for <em>'Current Member'</em>, it would not include contacts that had at least one active/current membership, but it turns out I was wrong. (We try our best to only keep one membership per contact, but there are sometimes circumstances where we have to keep multiple, e.g. one through a family member, where one is expired while the other one is still active.)</p>
  <p>Is this a but or a design opinion difference?</p>
  <p>If I set <em>'Display Results As'</em> to <em>&quot;Memberships&quot;</em>, then yeah, I'd expect that it'll pull the non-current memberships even though the contact may have another, active, one.</p>
  <p>What's the easiest way to pull contacts with non-current memberships? One way I can think of is to create two smart groups: 1) Current members; 2) Non-current members ... then a 3rd one with criteria <em>&quot;is part of Non-Current Members and is not part of Current Members&quot;</em> ... seems like a super complex way to achieve a pretty basic use case for a CRM (i.e., how can I easily identify and send a mailing to non-current users, e.g. for a membership drive campaign).</p>
  
Tags: <search><smartgroups><search-results><advanced-search>
Title: Advanced Search returns contacts with current memberships even though Current Member set to "No"
ThreadText: # Advanced Search returns contacts with current memberships even though Current Member set to "No"
  
  (Asked by: username_0 on 2022-09-07)
  
  When using *Advanced Search* and *'Display Results As'* is set to *"Contacts"*, I assumed that if I selected *"No"* for *'Current Member'*, it would not include contacts that had at least one active/current membership, but it turns out I was wrong. (We try our best to only keep one membership per contact, but there are sometimes circumstances where we have to keep multiple, e.g. one through a family member, where one is expired while the other one is still active.)
  
  Is this a but or a design opinion difference?
  
  If I set *'Display Results As'* to *"Memberships"*, then yeah, I'd expect that it'll pull the non-current memberships even though the contact may have another, active, one.
  
  What's the easiest way to pull contacts with non-current memberships? One way I can think of is to create two smart groups: 1) Current members; 2) Non-current members ... then a 3rd one with criteria *"is part of Non-Current Members and is not part of Current Members"* ... seems like a super complex way to achieve a pretty basic use case for a CRM (i.e., how can I easily identify and send a mailing to non-current users, e.g. for a membership drive campaign).
  
  **Tags:** search, smartgroups, search-results, advanced-search
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2022-09-07. Score: 1
  
  You should be able to do that with SearchKit. Look for contacts 'with (required)' a non-current membership and 'without' a current membership.
  
  > **Comments:**
  > **username_0**: Thank you - I'm unable to install it - getting an "Entity not loadedGrant" error. We don't use CiviGrant, and I don't feel compelled installing it just to enable SearchKit. I submitted a bug to the SearchKit lab, but it hasn't been accepted yet for some reason. I'll keep trying.  
  > **username_1**: You don't need CiviGrant enabled for SearchKit but there was a bug in that area when Grants were moved from core to a core extension.  Are you on the latest version?  If not, upgrading may help.  
  > **username_0**: Thanks again. I'm on CiviCRM 5.52.2, SearchKit 5.52.2  
  
  ---
  
  