Hippo supports using below operators when specifying an expression for a search request against scalar or vector fields.
| Operators | Description |
|---|---|
| and | Currently Hippo supports using "and", but "or" and "not" are not allowed |
| == | Equal to |
| < | Less than |
| <= | Less than or equal to |
| > | Greater than |
| >= | Greater than or equal to |
| in | in [1, 2, 3], returns records in which the selected column values falls within the values specified in filter |
| not in | not_in [1, 2, 3] |
| like | '_': match any single character, '%': match any character, '': escape character |