Incorrect Results in Query for Total Memberships

When working in a constituent query and querying on Summary Information for Memberships, Total Memberships may produce incorrect results and/or output incorrect information. 
Within a constituent query, the Summary Information for All Memberships field outputs each constituent associated with any membership of the constituents who meet the criteria. So if Constituent A has 2 memberships, and one of those memberships also includes Constituent B, both constituents will show up in the results. 

In order to only display those constituents who have 2 or more memberships, use a Membership query:
  1. Create a membership query
  2. Add the following criteria:
    1. History > Summary Information for All Memberships > Total Memberships is greater than or equal to 2
  3. Add desired output
  4. Run query

 

Steps to Duplicate

  1. Log into the Raiser's Edge
  2. Navigate to query and create a new query
  3. Add the following criteria:
History > Summary Information for All Memberships > Total Memberships is greater than or equal to 2
  1. Add desired output
  2. Run query and check results
    1. Constituents with 1 membership appear in the results

Was this article helpful?


Thanks for your feedback! Did this solve your issue?

Comments (optional):


Thanks for your feedback!
We're glad it was helpful but sorry it didn’t solve your issue. If you need assistance, click Chat with Support below.
We’re sorry to hear that. Please tell us why.

 I don't like how this works.

 The answer is confusing.

 The answer didn't match what I was searching for.

Additional Comments (optional):


Thanks for your feedback! If you need assistance, click Chat with Support below.
Thanks for your feedback. Help us make our products even better by sharing details in our Idea Banks or our online Community.
Thanks for letting us know. We'll work on clarifying the information in the article. If you need assistance, click Chat with Support below.
Thanks for letting us know. We'll work on updating the search engine to return more relevant results.