Specify filter options

This topic discusses the options that are and are not supported when using the filter option discussed in the previous topic. Note that the filter limitations discussed here are for time-enabled feature layers only. Filter options for ArcGIS hosted layers are fully supported.

When you select the Filter icon, the following filter dialog displays:

To add a filter, select an operator from the list, specify a value or field, then click APPLY FILTER. The results of the filter are displayed in the data table below the map.

To add a second clause to a filter to create a compound expression, click Add another expression. You can then select another operator and value.

Note: The Add a set option is not supported.

You can choose how the expressions should be joined. Select either All or ANY using the selection after Display features in the layer that match.... ALL indicates that the expressions are joined with a logical AND, while ANY indicates that the expressions are joined with a logical OR.

Note that sub-expressions must be joined with the same connector: either 'AND' or 'OR' but not a mixture of the two.

For example:

The following expression is supported:

county = 'alameda' and abbreviation = 'SHAY' and state = 'CA'

However, the following expression is not supported:

county = 'alameda' and abbreviation = 'SHAY' or state = 'CA'

For numeric field comparisons the product supports only the following comparison operators:

• =

• <>

• <

• <=

• >

• >=

In the following figure, the outlined options (is between, is not between, is blank, and is not blank) are not supported and will result in an error if selected:

For string field comparisons the product supports only the following:

• = (translates as 'is' in the filter dialog)

• <> (translates as 'is not' in the filter dialog)

For string comparisons, the outlined options in the following figure (starts with, ends with, contains, does not contain, is blank, and is not blank) are not supported and will result in an error if selected:

Also see Esri help for more information.