How to have a search constraint that's many-to-many

@Bubble, or anyone else, not sure if this is a bug, not possible, or there’s another way to do it.

  1. I am trying to create a filter (shows a “list of categories” to select from) for a repeating group on my page.
  2. I have a field that is a “list of Categories” on my data type – this field could have multiple values.
  3. I have a state field that holds a “list of Cateogries” on my page – populated by the items selected in step 1.
  4. When I click on one, or more, of the items in step 1 I am adding them to the State and want to perform a search.

The problem is that in the search constraint I cannot select “is in” as the operator and “contains” wants only one value. So, how can I do a many-to-many search constraint?

@Kfawcett Would advanced filter with intersect work for your use case?