Provide OR option among filter categories

There is currently no way to filter records that meet Constituency Code criteria OR Custom Field Criteria.    Within categories, we are offered "all of/any of" options, but not between categories. For example, I would like a list that includes records with the Constituency Code "Activist" OR a particular value in our Custom Field "Special Lists."  I can do it in a database view query, but not in NXT Lists.  

  • Gary Cook
  • Sep 28 2017
  • Shipped
  • Attach files
  • Admin
    Heather McLean commented
    24 Sep 16:11

    Thank you everyone for the feedback and discussion.

    We reviewed the original request behind this idea and the primary need was the ability to support exclusion and "NOT" or "OR" scenarios when building and refining Lists. With the introduction of Query filters in NXT Lists, users can now exclude records that match selected criteria by leveraging Query-based filtering. This delivers the core capability requested in this idea, which is why we have marked it as Shipped.

    It's also important to note that this idea was created before web view Query capabilities were available. Since then, the platform has evolved significantly. Query-backed Lists now provide a flexible way to support a broad range of exclusion scenarios without requiring us to introduce a dedicated NOT operator for every filter type.

    As a result, we believe the original, overarching request has been addressed. Rather than keeping this idea open indefinitely to represent a growing collection of individual filtering needs, our goal is to focus on specific remaining use cases. If there is a scenario that cannot be accomplished with the current Query-backed filtering experience, please submit a new idea describing that workflow and desired outcome so we can evaluate and prioritize it independently.

    Thank you to everyone who voted, provided examples, and helped us better understand how customers use Lists in their day-to-day work.

  • Leah R commented
    January 13, 2023 15:15

    Please merge with idea https://renxt.ideas.aha.io/ideas/RENXT-I-3520 - these are the same.

  • Jennifer Vincent commented
    August 29, 2019 14:39

    I would love to see all of the choices that are available on database side - especially those that are "blank" or "not one of." 

  • Peter Folkert commented
    March 27, 2019 13:04

    Some lists don't have "one of" as well.

  • +106