Answers.Body: <p>Are you dealing with failed recurring contributions or simply contributions that don't exist?</p>
  <p>If it's failed recurring contributions, you can do:</p>
  <ul>
  <li>Memberships</li>
  <li>Where Recurring Contribution is not empty and Status is
  one of Current, New</li>
  <li>Without Membership Recurring Contribution where Number of Failures is greater than 0</li>
  </ul>
  <p>If it's that contributions don't exist, you could do:</p>
  <ul>
  <li>Contacts</li>
  <li>with Memberships where Recurring Contribution is not empty and Status is one of Current, New</li>
  <li>without Contributions where Recurring Contribution is not empty, date in range last 30 days, and Status = Completed</li>
  </ul>
  <p>This assumes your contacts don't have other recurring contributions.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-12-22T11:15:21.257Z
Answers.Text: Thank you @Lars - I think I have been able to construct the Failed Payments version, but I'm struggling with the Missing Payments. I can't see how this distinguishes between monthly and annual payers?
Answers.UserDisplayName: Simon Thornton-Wood
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-12-22T17:14:10.860Z
Answers.Text: You should be able to add a where for Frequency Units for the Recurring Contribution, assuming your annual ones are all one year as opposed to 12 months (or if you need to cover 12 months too, then you can add Interval).
Answers.UserDisplayName: Lars SG
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-12-20T17:07:39.723Z
Answers.LastActivityDate: 2022-12-20T17:07:39.723Z
Answers.UserDisplayName: Lars SG
Body: <p>I would like to construct a query in SearchKit - if it is possible - that answers the question:
  &quot;Find active (Current, New) Memberships where Contributions recur monthly and the last Contribution was more than one month ago.&quot;, and separately,
  &quot;Find active Memberships where Contributions recur annually and the last Contribution was more than one year ago&quot;.
  This would be enormously helpful in trapping situations where recurring payments have failed for a variety of reasons. Before SearchKit, there was no hope (it seems) of finding these Memberships without a large set of search strategies, but with SK, the possibility of a simple solution looks tantalisingly close...</p>
  
Tags: <recurring-contributions><searchkit>
Title: SearchKit: identify current Memberships where last recurring payment or instalment is too old
ThreadText: # SearchKit: identify current Memberships where last recurring payment or instalment is too old
  
  (Asked by: username_0 on 2022-12-20)
  
  I would like to construct a query in SearchKit - if it is possible - that answers the question:
  "Find active (Current, New) Memberships where Contributions recur monthly and the last Contribution was more than one month ago.", and separately,
  "Find active Memberships where Contributions recur annually and the last Contribution was more than one year ago".
  This would be enormously helpful in trapping situations where recurring payments have failed for a variety of reasons. Before SearchKit, there was no hope (it seems) of finding these Memberships without a large set of search strategies, but with SK, the possibility of a simple solution looks tantalisingly close...
  
  **Tags:** recurring-contributions, searchkit
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2022-12-20. Score: 1
  
  Are you dealing with failed recurring contributions or simply contributions that don't exist?
  
  If it's failed recurring contributions, you can do:
  
  * Memberships
  * Where Recurring Contribution is not empty and Status is
    one of Current, New
  * Without Membership Recurring Contribution where Number of Failures is greater than 0
  
  If it's that contributions don't exist, you could do:
  
  * Contacts
  * with Memberships where Recurring Contribution is not empty and Status is one of Current, New
  * without Contributions where Recurring Contribution is not empty, date in range last 30 days, and Status = Completed
  
  This assumes your contacts don't have other recurring contributions.
  
  > **Comments:**
  > **username_0**: Thank you @Lars - I think I have been able to construct the Failed Payments version, but I'm struggling with the Missing Payments. I can't see how this distinguishes between monthly and annual payers?  
  > **username_1**: You should be able to add a where for Frequency Units for the Recurring Contribution, assuming your annual ones are all one year as opposed to 12 months (or if you need to cover 12 months too, then you can add Interval).  
  
  ---
  
  