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”.
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”
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”
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.
Best…
Mike
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
