Answers.Body: <p>You can create a smart group with all current membership.</p>
  <p>Using searchkit you can build a list for all expired membership and not in above create group.</p>
  <p>Hth</p>
  <p>Pradeep</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2024-02-19T08:51:09.513Z
Answers.Text: Thanks, I think it is a good solution, I hadn't thought of that. If I wanted to filter by group in Form Builder, I found olnly "In groups" and not "Not in groups". Is there a solution? Then please can you give me a reference (documentation) to create a custom filter with Form Builder, not based on a custom field, but on a set of conditions? This is to don't have to think and set filters every time and without creating "n" menus or forms.
Answers.UserDisplayName: masetto
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2024-02-19T09:22:29.223Z
Answers.Text: Perhaps for complex filters it is better to create nested smart groups.
Answers.UserDisplayName: masetto
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2024-02-18T17:57:35.107Z
Answers.LastActivityDate: 2024-02-18T17:57:35.107Z
Answers.UserDisplayName: Pradeep Nayak
Body: <p>I need to send reminders to expiring memberships. But I would like to exclude all those that have been &quot;renewed&quot; with another membership type (bought another membership type that fundamentally continues the previous membership).</p>
  <p>I have many membership types, there are no old or new membership types, but for example a member can renew for 1 year or 2 years for different types (free book, access to digital magazines...).<br />
  I have to send the reminder only to those who have not renewed any membership.</p>
  <p>How can I do this? It would be preferable for me to use SearchKit. It would also be fine to do a custom where, but I don't know how to do it in a custom extension.</p>
  
Tags: <civimember><searchkit><custom-search>
Title: Get list of all expiring memberships, but excluding all those that have been "renewed" with another membership type
ThreadText: # Get list of all expiring memberships, but excluding all those that have been "renewed" with another membership type
  
  (Asked by: username_0 on 2024-02-18)
  
  I need to send reminders to expiring memberships. But I would like to exclude all those that have been "renewed" with another membership type (bought another membership type that fundamentally continues the previous membership).
  
  I have many membership types, there are no old or new membership types, but for example a member can renew for 1 year or 2 years for different types (free book, access to digital magazines...).  
  I have to send the reminder only to those who have not renewed any membership.
  
  How can I do this? It would be preferable for me to use SearchKit. It would also be fine to do a custom where, but I don't know how to do it in a custom extension.
  
  **Tags:** civimember, searchkit, custom-search
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2024-02-18. Score: 2
  
  You can create a smart group with all current membership.
  
  Using searchkit you can build a list for all expired membership and not in above create group.
  
  Hth
  
  Pradeep
  
  > **Comments:**
  > **username_0**: Thanks, I think it is a good solution, I hadn't thought of that. If I wanted to filter by group in Form Builder, I found olnly "In groups" and not "Not in groups". Is there a solution? Then please can you give me a reference (documentation) to create a custom filter with Form Builder, not based on a custom field, but on a set of conditions? This is to don't have to think and set filters every time and without creating "n" menus or forms.  
  > **username_0**: Perhaps for complex filters it is better to create nested smart groups.  
  
  ---
  
  