5.4 Operators

Each data type has specific operators that can be used with a given keyword.

This section covers the following topics:

5.4.1 UNARY

UNARY keywords have no operators (or Value data). Follow a UNARY keyword filter expression with either a Closing Parenthesis or another Simple Statement. For example, the filter expression "(APPOINTMENT)" will find all Appointment messages.

There is one exception to this rule. The NOT operator can proceed a UNARY keyword. The following are a few examples:

  • To find all messages that are not appointments, use (NOT APPOINTMENT).

  • If you want to find the item status of messages that are not read, use (NOT READ).

  • If you want to find the item status of messages that are not opened, use (NOT OPENED).

5.4.2 Date

Date keywords use the following operators:

Operator

Description

=

Equal to

>=

Greater than or equal to

>

Greater than

<=

Less than or equal to

<

Less than

5.4.3 Numeric

Numeric keywords use the following operators:

Operator

Description

=

Equal to

>=

Greater than or equal to

>

Greater than

<=

Less than or equal to

<

Less than

<>

Not equal to

5.4.4 String

String keywords use the following operators:

Operator

Description

Matches

Equals, exactly matches the string Value

Contains

Field has the value string in it

BeginsWith

Field has the value string as the first characters of the data string

DoesNotContain

Field does not contain the value string

NOTE:String operators are not case sensitive.

5.4.5 Enumerated

Enumerated keywords use the following operators:

Operator

Description

=

Equal to

<>

Not equal to