Using check lists to retrieve data from a data master

prototype user shared this question 1 year ago
Answered

I am trying to write an expression that will retrieve records from a data mater based on values selected in a check list widget. For example, each checkbox in a list represent colors: red, green, and blue. If the user selects the red and blue checkboxes I want to retrieve all items that are either red or blue. I am able to get it to work if only a single checkbox is chosen, but when multiple checkboxes are selected it doesn't work at all. It seems like if red and blue are chosen it is mapping it to a string "red,blue" and will only match a data master column that also happens to have the string "red,blue". Please advise.

Comments (1)

photo
1

Hi there,


What expression have you created to filter the data master? Does it include filtering by the attribute color using the 'OR' comparator, or does it use '='?


Best,

Danielle