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 .
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.
This is the same issue as https://renxt.ideas.aha.io/ideas/RENXT-I-3334
Can they be linked?
Attachments Open full size
We need this too. I have to create static queries for now and it's not the most efficient way to do it.
Attachments Open full size
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.
Attachments Open full size
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.
Attachments Open full size
Agree as well. This feature is paramount if the List function will continue to limit table field searches to the first 100 records.
Attachments Open full size
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!
Attachments Open full size