5.4.4. Supported Operators for Granular Search
表5.1 Logical Operators
| Operator | Description |
| and | Combines search criteria. |
| not | Negates an expression. |
| has | Object must have a specified property. |
表5.2 Symbolic Operators
| Operator | Description |
| = | Is equal to. An equality comparison that is case-sensitive for text fields. |
| != | Is not equal to. An inversion of the = operator. |
| ~ | Like. A case-insensitive occurrence search for text fields. |
| !~ | Not like. An inversion of the ~ operator. |
| ^ | In. An equality comparison that is case-sensitive search for text fields. This generates a different SQL query to the Is equal to comparison, and is more efficient for multiple value comparison. |
| !^ | Not in. An inversion of the ^ operator. |
| >, >= | Greater than, greater than or equal to. Supported for numerical fields only. |
| <, ⇐ | Less than, less than or equal to. Supported for numerical fields only. |