1

Hopefully very easy but I want to build a search kit of people in a mailing group (Historic Event Attendees) who are NOT current members.

When I do Status = Empty, I get 378,

but when I do Status = Does not Include New, Current, Renewal, Grace, I only get 40!

Please can you suggest what extra query I need to add to get this to show me people in the group who are NOT current members, as I should get more in the second query, as that would include those with status lapsed and cancelled.

Search Filter

Thanks

1 Answer 1

1

You have made Join as 'With(optional)' and with status empty will give you contacts who never had membership

If you do OR clause then you should get 378+40 results approx with group by

enter image description here

2
  • Many thanks Pradeep! Commented Mar 26 at 12:30
  • You can also change the join from "With" to "Without"!
    – Coleman
    Commented Mar 26 at 13:02

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.