I have a filter criteria where we need to check if a column has one of many different values. The ideal would be to use an IN clause, as you would use in a database. Right now that option does not exist, do you think it ever will?
Is the intent of the Filter Stage to allow 'SQL-like' where clauses? If so, you would think an 'IN' clause would be an obvious and necessary addition.
For now, I am stuck with
Code: Select all
field1 = 'Y'
and (
field2 = 'A'
or field2 = '#'
or field2 = 'C'
or field2 = 'H'
or field2 = 'K'
or field2 = '2'
)
My actual filter is more complex, but you get the idea. I really like keeping the 'where' logic in one place, but sure wish it could be simplified:
Code: Select all
field1 = 'Y'
and field2 in ('A', '#', 'C', 'H', 'K', 'Z')
An IN clause should obviously be able to handle any normal character or numeric datatype, just like a database.
Brad.