How to add your knowledge

Logical Operators

    Table of contents
    No headers

    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)