WHERE IN Statement in Custom Filter

[dshaw]

Can you use a WHERE IN statement in a custom filter?

Where [zip] in ("12345", "98765", "65432")

Or, is there another statement in the custom filter to accomplish the above without joining multiple filters?

[CharlieS · Accepted solution]

The custom filter syntax doesn't require the "where". This is the expression:

[ZIP] in ("12345","98765","65432") 

[dshaw]

Thanks.  I wonder if there is a list of common custom filter syntaxes?  Or, is it just SQL with Select and Where?

[CharlieS · Accepted solution]

Tools where you can enter custom expressions (ex: Filter, Formula, Multi-Field Formula, Multi-Row Formula) also feature a list of functions that can be used for reference or double-clicked to insert. The expression used in this case is found in the "Operators" section.

[mbogusz]

Thank you @CharlieS.  I would just like to add this syntax can be used in the Dynamic Select tool as well.  My use case involved finding the Fields I had deselected (with a Select tool) with the Field Info tool via Joining and then using the Summarize tool 'concat' function to come up with the syntax to paste into the Dynamic Select tool.

[MichelleMitchellLutz]

Just to add, if the field you're filtering is numeric (rather than string), you do not need the quotes. [Account Number] in (123,456,798).