Add "Or" Criteria to Lists

Currently, in Lists, you can set filters for all the criteria you want to include, but it only treats filters with "AND" query logic. You have to create separate lists for additional criteria. There should be an "Or" logic to add layers of criteria within lists. For example, if you wanted to pull a list all constituents with a specific degree or all constituents who had given to a particular fund, you should be able to add an "or" layer. Right now, you'd have to make those into two separate lists. Since Lists is the closest thing to "queries" in RE NXT, it should be built out more with some additional features. This could even be an "Advanced Logic" option where maybe only certain users could be given access as to not confuse a basic list user.

  • Nikki Long
  • Sep 2 2020
  • Reviewed: Voting Open
Lists
  • Attach files
      Drop here to upload
    • Zeke Huish commented
      03 Feb 23:56

      This has my vote, it seems strange that you cannot use the Exclude and Include solicit code filters in a more functional way especially when you have opt in and opt out solicit code. Having both of the filters treated as a 'and' instead of a 'or' seems counter productive for how the system is set up to run

      Attachments Open full size
    • Meredith Friedman commented
      March 15, 2022 14:57

      I strongly support Art's comment as well. I'm going to look for that suggestion and vote that up also.

      Attachments Open full size
    • Art Bryman commented
      February 07, 2022 17:17

      This should be combined with "Filters for NXT Lists should include the option of NOT" suggestion. Having only "AND" (and not making it obvious) was a poor design choice, and needs to be rectified ASAP. We need "OR", "NOT", and grouping ("(" and ")") as list filters to make them useful.

      Attachments Open full size
    • max marrie commented
      January 30, 2022 16:08

      Thank you for sharing this. It helps me alot to add a layers on home page of my website labour hire melbourne. RE NXT really helped me alot to manage my funds and I think it is one of the best platform for this purpose.

      Attachments Open full size
    • Justin Barrett commented
      August 26, 2021 13:40

      Not having this option makes lists very limiting, and have to use the Database view.

      Attachments Open full size
    • Cherie Thibault commented
      March 04, 2021 18:33

      I certainly agree with the others, NXT lists should have all of the capabilities as the database queries and exports. It would be a nightmare if the database was eliminated before the updates can be made to NXT.
      Cherie’

      [cid:image001.jpg@01D52127.136D9ED0]
      Cherie’ Thibault
      Donor/Data Support Specialist
      FAMILY TREE, INC
      Gifts and Community Support
      (P) 303.403.5891
      (O) 303-422-2133 x735
      www.thefamilytree.org
      [cid:image002.jpg@01D52127.136D9ED0] [cid:image003.jpg@01D52127.136D9ED0]
      Empowering Change. Transforming Lives.

      image001.jpg
      image002.jpg
      image003.jpg
      Attachments Open full size
    • +526

    Related ideas