How to Filter List of Option Set using List of Option Sets

I have a website for restaurants. Where I have assigned multiple “Ambience tags(Ambience Type)” to each restaurant using List for the option set “Ambience”.
Screen Shot 2023-02-11 at 11.25.38 AM
This “Ambience Type” is a list of Option Set

I want to filter the restaurants in my search results by selecting one or more “Ambience Type”
Screen Shot 2023-02-11 at 11.24.36 AM

What is the best way to use the filter so to mean "show me the restaurents that have all of this selected “Ambience” in its list of “Ambience Type”
Screen Shot 2023-02-11 at 11.39.35 AM

Hi there, @yamirb… if I understand your post correctly, you need to use the intersects with operator and do a count of the intersection between two lists to see if the count is equal to the count of the number of items in the filter.

Hope this helps.


Thank you @mikeloc for the clue. It worked.
In place of “intersects with”, I went with “contains list” since I didn’t want any of the selected input for the filter but all of the selected input for the filter. So
Screen Shot 2023-02-11 at 8.08.35 PM :man_dancing:

1 Like