An operator determines how search values are compared against the search field. The available operators depend on the search field that you select.
Some of the operators use the same syntax, but have different meanings depending on the search field. The following table describes the operators that you can select in the Query Builder:
| Operator Name | Operator Query Text | Description |
|---|---|---|
| After | :> | For dates only. The date in the search field is after the date that you enter as the search value. |
| Before | :< | For dates only. The date in the search field is before the date that you enter as the search value. |
| Contains | : | The search value is included somewhere in the search field. |
| Ends With | :$ | The search field ends with the search value. |
| Equals | := | The search field is equal to the search value. |
| Greater Than | :> | The search field is greater than the search value. |
| Is | : | The search field is equal to the search value. This operator is for search fields that can only have true or false values. |
| Less Than | :< | The search field is less than the search value. |
| Not Equals | :! | The search field equals anything except for the search value. |
| On | : | For dates only. The date in the search field is the same as the date that you enter as the search value. |
| Starts With | :^ | The search field begins with the search value. |