where fieldName in [value1, value2]
I saw that "where fieldName in [value1, value2]" is the same as "where fieldName=value1 or fieldName=value2 which is great the thing is that when using the in array I can't add an "and" after which where in "or" I can do an "and" after. For example:
where name in [value1, value2] and x=y (doesn't work)
where name=value1 or name=value2 and x=y (works)
Anything I missed?