If using a SQL filter you just enter the where clause, e.g. columnName in ('value1','value2')
We got that answer... 'what comes after the where'. But it seems like only simple where clauses can be used. I want to do something like below but it is deemed invalid.
WHERE ColumnName = (Select max(ColumnName) FROM Object)
Only simple where clauses are supported.