Logical Operator Reference
Logical operators are available from the Operator menu. They create conditions that return a value for a text property if it matches a particular pattern, or appears within a particular list.
When you create an expression for geospatial features, you can use the following logical operators:
| Operator | Definition | Syntax |
|---|---|---|
| IS NULL | Returns the specified property if it is null. An expression with a bitwise or arithmetic operator evaluates to NULL if any one of the operands is NULL. | Property IS NULL |
| IS NOT NULL | Returns the specified property if it is not null. An expression with a bitwise or arithmetic operator evaluates to NULL if any one of the operands is NULL. | NOT Property IS NULL |
| AND | Combines conditions and matches a value if it meets all conditions. | Expression AND Expression |
| OR | Combines conditions and matches a value if it meets any one of the conditions. | Expression OR Expression |
| NOT | Negates a Boolean expression. | NOT Value |
| ( ) | Groups the selection in parentheses. | (Value, Value) |