An AttributeFilter defines a non-spatial searching constraint or query using a comparison. The following comparison operators are supported. Examples illustrating how they may be used are provided.
- EqualTo – This filter can be used to find all of the features that are in a particular country subdivision.
- NotEqualTo – This filter can be used to find all of the features that are not in a particular country subdivision.
- LessThan – Define a search to find all features where a population is less than a given value. For example, Population < 100,000.
- GreaterThan – Define a search to find all features where a population is greater than a given value. For example, Population > 200000.
- LessThanOrEqualTo – Define a search to find all features where a population is less than or equal to a given value. For example, Population <= 100,000.
- GreaterThanOrEqualTo – Define a search to find all features where a population is greater than or equal to a given value. For example, Population >= 200,000.
- Like – This filter can be used to define a search based on a pattern, such as find all features where the country name starts with A. For example, CountryName like A%.
- Between – This filter can be used to select features where the population is within a range of two values. For example, Population between 100,000 AND 200,000.
- IsNull – This filter can be used to select features that do not have any value set for an attribute, such as Date of Birth is null (or not set). For example, DATE_OF_BIRTH is null.