I’m trying to filter a data master based on another data master multiple selections
Data master “category”
red
blue
green
Data master “products”
Pant,red,10
Pant,blue,20
Shirt,red,12
Shirt,green,20
On a column multiple select I choose blue,red
So I’d like to get
Pant,red,10
Pant,blue,20
Shirt,red,12
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?
Thank you
Replies have been locked on this page!