Search for... Constraint Contains any

[mikeloc]

Hi there, @eric10… this thread Nigel just posted sounds like what you are trying to accomplish, so I thought you might want to take a look at it.

List A contains at least 1 of List B

So, I had a question from a new Bubbler who was trying to do a filter by Tags. The database thing has a list of tags (they are option sets, but don’t think that is relevant) and the page has a multidropdown of tags. So the search filter can be done by an Advanced Filter… this thing’s list of tags : intersects with multidropdowns value : count > 0 The question was “is that really the easiest way” ? “Contains” doesn’t work because that checks for a single tag. Have been doing it with count>0…

Try adding :count>0 after the intersects with operator and see if that produces the desired result.

Hope this helps.

Best…
Mike