Upvote 1

I’m trying to filter a data master based on another data master multiple selections

Need Answer Georgios Vranopoulos 3 years ago

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

Leave a Comment
 
Attach a file