base/database/query/README.md
( and )and and or
not
not (...)name not matches "^King "Supported by all feeders:
fieldfield.submap.0map.#Please note that some feeders may have other special characters. It is advised to only use alphanumeric characters for keys.
| Name | Textual | Req. Type | Internal Type | Compared with |
|---|---|---|---|---|
| Equals | == | int | int64 | == |
| GreaterThan | > | int | int64 | > |
| GreaterThanOrEqual | >= | int | int64 | >= |
| LessThan | < | int | int64 | < |
| LessThanOrEqual | <= | int | int64 | <= |
| FloatEquals | f== | float | float64 | == |
| FloatGreaterThan | f> | float | float64 | > |
| FloatGreaterThanOrEqual | f>= | float | float64 | >= |
| FloatLessThan | f< | float | float64 | < |
| FloatLessThanOrEqual | f<= | float | float64 | <= |
| SameAs | sameas, s== | string | string | == |
| Contains | contains, co | string | string | strings.Contains() |
| StartsWith | startswith, sw | string | string | strings.HasPrefix() |
| EndsWith | endswith, ew | string | string | strings.HasSuffix() |
| In | in | string | string | for loop with == |
| Matches | matches, re | string | string | regexp.Regexp.Matches() |
| Is | is | bool* | bool | == |
| Exists | exists, ex | any | n/a | n/a |
*accepts strings: 1, t, T, true, True, TRUE, 0, f, F, false, False, FALSE
If you need to use a control character within a value (ie. not for controlling), escape it with \.
It is recommended to wrap a word into parenthesis instead of escaping control characters, when possible.
| Location | Characters to be escaped |
|---|---|
Within parenthesis (") | ", \ |
| Everywhere else | (, ), ", \, \t, \r, \n, (space) |