I’d like to specify a filter that gets the value of two columns - it checks if a string (in col 1) is in a list of strings AND if an int (in col 2) is less than 50.
Is this possible?
@klamike Yes. The filter_query accepts complex filter syntax.
There’s currently no operator for in a list so you’ll have to OR them all inside a (...) block.
Something like ({col1} = 'value1' || {col1} = 'value2' || {col1} = 'value3') && {col2} < 50 should do the trick.