Query Language
Since High Systems is built on SQL, we offer a very dynamic and powerful query language. In this guide, we'll look at the different components of a query and how to build one.
Structure
The structure of High Systems query language consists of 4 components:
- Field ID
- Operator
- Value
- Grouping
These components are composed in the following format:
{'field id'.operator.'value'}
To support more complex queries, you can group them with parentheses and separate them with and and or.
The curly braces, apostrophes and periods are all required characters.
Field ID's can be found by going to a Table's Settings and clicking on Fields.
Operators
| Operator | Description |
|---|---|
| = | is equal to |
| != | is not equal to |
| > | is greater than |
| < | is less than |
| >= | is greater than or equal to |
| <= | is less than or equal to |
| starts-with | starts with |
| not-starts-with | does not start with |
| ends-with | ends with |
| not-ends-with | does not end with |
| like | contains |
| ilike | contains (case-insenstive) |
| not-like | does not contain |
| not-ilike | does not contain (case-insenstive) |
| is-during | is during |
| not-is-during | is not during |
Structure
{'fieldid'.=.'value'}