Query Builder Statement Operators
When you add a conditional statement, you must select an operator. The operator is used to determine whether or not a record meets the criteria defined in a conditional statement. When you add a conditional statement, the default operator and other available operators depend on the field type.
The following table describes all of the possible operators.
| Operator | Selects a record if the applicable field contains a value that: |
|---|---|
| Starting With | Starts with the value defined in the Value is box. |
| Contains | Contains the string defined in the Value is box. |
| (=) equal to | Equals the value defined in the Value is box. |
| (<>) not equal to | Is not equal to the value defined in the Value is box. |
| (<) less than | Is less than the value defined in the Value is box. |
| (<=) less than or equal to | Is less than or equal to the value defined in the Value is box. |
| (>) greater than | Is greater than the value defined in the Value is box. |
| (>=) greater than or equal to | Is greater than or equal to the value defined in the Value is box. |
| In | Contains one of the strings defined in the Value is box, such as an embedded literal OR statement. You must use quotation marks around any values to indicate what it should search for. |
| does not contain data | Is null (contains no value). |
| does contain data | Is not null (contains any value). |
| within last xxx days | Is a date within the last "xxx" days (past). Enter either an integer or two integers separated by a comma for a date range. |
| within next xxx days | Is a date within the next "xxx" days (future). Enter either an integer or two integers separated by a comma for a date range. |
