Merged idea

This idea has been merged into another idea. To comment or vote on this idea, please visit RENXT-I-3334 Filters for NXT Lists should include the option of NOT .

Include an "Exclude" filter on the NXT Lists Merged

I like the NXT lists, but it would be nice if it could have slightly more robust filters. One that I would find extra helpful would be a "not equal to" or "exclude". For instance, I could say gifts between this date and this date, but EXCLUDE all gifts for the Golf Tournament.

  • Kari Hammett-Caster
  • Apr 25 2016
  • Reviewed: Voting Open
  • Paul Sinclair commented
    July 13, 2020 05:00

    This is the same issue as https://renxt.ideas.aha.io/ideas/RENXT-I-3334

    Can they be linked?

  • Delia Escobar commented
    October 16, 2019 20:31

    We need this too. I have to create static queries for now and it's not the most efficient way to do it. 

  • Teddi Taylor commented
    November 15, 2017 21:03

    Yes, this would help the issue with not having the ability to filter on constituent code dates. Converting an Individual to Organization (for Estates particularly) puts an end date on their constituent codes, so they still show up in lists, even though it's not an active constituent code. If I could exclude Estates, it would mean I wouldn't have to go delete a bunch of old constituent codes. There are a lot of other uses as well. 

  • Natalie Washnieski commented
    October 26, 2017 14:24

    Yes- this is needed! We use primary and secondary accounts to filter our consitutents and being able to exclude secondary would be helpful and necessary for our list building. 

  • Ned Forster commented
    June 26, 2017 13:32

    Agree as well. This feature is paramount if the List function will continue to limit table field searches to the first 100 records.

  • Susanne Larsen commented
    August 26, 2016 16:43

    Yes - I agree. It would be great if in List filters you could say "not one of" or "is blank".  For example, I need to run a list of high wealth constituents who are not assigned to a gift officer and I cannot do this, yet. Thanks!

  • +87