Multiple frontend filters table widget

Question

Hello, 

I'm trying to apply multiple frontend filters to a single field in a table widget and can't figure out how to do so. 

For example, if I were filtering on a dataset of bicycles and wanted a table with all bicycles that are blue, red, or green how would I do that?

I've tried frontend filtering where Color like Blue OR Red OR Green but can't get anything to work. 

Thanks!

Answer 1

For those who struggle with a similar issue, if you use the IN operator for the filtering through the table widget like so:

Color IN Blue,Red,Green

It works. 

Note that Color is the column, IN is the operator, and Blue,Red,Green is the value. Please take note the lack of spaces and capitalization in the value. These should match strictly to possible values in the Color column.