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?
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.