Layered Filters + AND/OR

Right now, it seems like "filters" are just "AND" (a filter is either "On" or "Off").

It would nice to be able to get an "OR" capability.

And then to "layer this". So for example:

  • Filter set one (All, Domestic, Foreign)
  • Filter Set Two (USD, GBP, EUR)

You then could have two rows of buttons/toggles. In this case, row one might be set to "AND" and row two might be set to "OR".

3 Likes

+1,000,000

+1

Yes! I kind of envision it like Excel or Google Sheets does Filtering, for a table view:

Each table column allows you to set a filter, selecting ALL, selecting BLANKS, or selecting particular values. Additionally, as Excel does, you can filter based on "Text Filters..." which includes Equals, Does Not Equal, Begins with, Ends with, Text Contains, Text Does Not Contain, and Custom Auto Filter...which gives all sorts of flexibility.

If each column of your table allowed for this kind of filtering, you'd have unlimited ability to drill-down or expand to find your precise criteria. 

My clients want the ability to view products that contain a certain ingredient "sodium" somewhere in the ingredient name that is an ACTIVE ingredient for that product, AND also contains a different ingredient, like "iodine" that is INACTIVE for that product, while also filtering off of the product's Manufacturer or whether the product status is allowed or prohibited. It's a lot of if/then scenarios all nested. 

Having a search function do this as well would be awesome. The biggest issue I have now is that filtering on "contains" doesn't really contain - you are still forced to choose from specific items. We have tons of ingredients that contain sodium, and I don't want to select each one - I just want the filter to find all ingredients with "sodium" somewhere in the word. 

Thanks for considering this!

Yes! Definitely need OR option and way to layer it with AND.

+1

Any news on when the filtering features will be upgraded?  

The main issue I see with the AND/OR filters is that I often want to filter by one set of parameters, then include several other parameters after that.  See example below:

1.) Filter by Location

2.) AND Filter by Product A

3.) OR Filter by Product B

The issue is that changing filter 3 to OR also changes filter 2 to OR.  Vice versa as well:  changing filter 3 to AND also changes filter 2 to AND.

Seems like it's a logical issue with the nesting of the filters.

THANKS!

+1

I agree, +1 for this

Honestly… it has been five years since this was requested. Are we just never going to be able to filter by AND/OR at the same time? This seems pretty basis to implement. What’s the hold up?

2 Likes

Any word on this? Are And/Or filters in the works?

This is a show stopper. Come on guys. Get this done to make it the perfect go to tool for developers ans users.
CAN WE GET AN ANSWER WHEN THIS WILL BE DONE??

Use Case:
Need a filter where the user can find cars that match any combination:

Store = Chicago or store = Detroit

and

Automobile make = Ford

and

New or used = new

and

Model = F-150 or Model = F-250

Color = red

or

color = blue--------------

Hi All -
I totally agree, we are not up to expectations on a seemingly simple filtering capability.
I’ve got a bunch of stories queued up (including and beyond the AND + OR) for advanced sorting and filtering functionalities, and to be transparent, I don’t think we will be able to implement them this quarter. As we begin planning out Q2, we will see how many of the stories we can fit in.
@EdCooper15510 did this solution not end up working for your use case?
Thanks,
Kara

With all due respect, my personal opinion is that this should be a high priority for Q1.
Retrieving data is upmost in the minds of builders for their users.
I consider this critical functionality.