Justinmind-logo
 

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

Georgios Vranopoulos shared this question 3 months ago
Need Answer

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