where fieldName in [value1, value2]

Hey

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?

1 Answer

« Back to question.

Hi,

Can you try using parentheses:

where (name in [value1, value2]) and x=y

Thanks.

Thanks a lot it worked