Canceled memberships pulling in query even when using is dropped field

When creating a query or exporting information from Altru you may notice that canceled memberships still pull into your query even though you have used the is dropped is equal to no criteria to filter out dropped members. 
In certain cases a membership may be canceled in Altru but the constituent was not dropped from the membership as the membership still has members when it is canceled. To remove those memberships from the query you would need to add an additional field
  1. In a constituent's query under the browse for fields in section expand member
  2. Then click on Membership >drag the status field from the middle column to the include records where section
  3. Change the first drop down to "not equal to" and the second drop down to "canceled"
  4. User-added image
If you need to also exclude dropped members from your query use these steps

Environment

 Altru Arts & Cultural

Was this article helpful?