I’m trying to filter a data master based on another data master multiple selections
Data master “category”
Data master “products”
On a column multiple select I choose blue,red
So I’d like to get
Something like the “in” sql condition.
Select * from products where color in(red,blue)
All the logic functions (=, has, etc) use strings not collections and the data function (add, subtract) will work with single column entities and there is not “intersection” (sets) function
Any suggestions on implementing the aforementioned functionality?