Filter using OR

I am trying to select only those records that have a certain attribute. As long as the record has one of multiple forms of this attribute, it should be included, otherwise it should be excluded. The attribute is Int. My condition on the filter looks something like this:

(field name)==xxx||yyy||zzz

This isn't working. It is returning all records in teh true stream and none in the false stream.

Preparation

Accepted answers

Ned

You can use a IN statement:

[Field1] IN (5,6,8)

That does exactly what you are asking for.

Ned

And just to add 1 more detail: If you want to use the || or OR syntax (OR and || are synonyms) , you need to specifiy the field name multiple times:

[field]==a OR [field]==b OR ...

SeanAdams

Hey @raddi

Are you OK to mark @Ned 's solution as 'Solved"? That way, this can contribute to the body of knowledge that folks can search for worked solutions.

Community Admins - if @raddi is not able to get to this in a week or two - would you mind marking this as solved?

Thank you

Sean

All comments

Ned

You can use a IN statement:

[Field1] IN (5,6,8)

That does exactly what you are asking for.

Ned

And just to add 1 more detail: If you want to use the || or OR syntax (OR and || are synonyms) , you need to specifiy the field name multiple times:

[field]==a OR [field]==b OR ...

SeanAdams

Hey @raddi

Are you OK to mark @Ned 's solution as 'Solved"? That way, this can contribute to the body of knowledge that folks can search for worked solutions.

Community Admins - if @raddi is not able to get to this in a week or two - would you mind marking this as solved?

Thank you

Sean

ckirgiz

Is this still applicable? I tried both solutions but it did not work.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703