Each data type has specific operators that can be used with a given keyword.
This section covers the following topics:
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).
Date keywords use the following operators:
Operator |
Description |
---|---|
= |
Equal to |
>= |
Greater than or equal to |
> |
Greater than |
<= |
Less than or equal to |
< |
Less than |
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 |
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.
Enumerated keywords use the following operators:
Operator |
Description |
---|---|
= |
Equal to |
<> |
Not equal to |