Summary
Sometimes a basic query isn't enough to get you the specific results you require. Oneserve offers a bespoke query language known as OQL to allow you to craft advanced search terms to build up your search views.
Guide
Keywords
Keywords in OQL are similar to those used by other query languages. These are words used to combine queries and define the logic of the search. Below is a list of available keywords:
AND
- Displays a record if conditions separated byAND
areTRUE
OR
- Displays a record if and one of the conditions separated byOR
isTRUE
NOT
- Displays a record if the stated conditions areNOT TRUE
EMPTY
- Displays a record if the requested valueIS NULL
Operators
An operator is a symbol or word that is used to compare the value of a field on its left with the value(s) or functions on its right. Only records that return a TRUE
value from this comparison will be included in the results.
Operators included in OQL are:
EQUALS
or=
NOT EQUALS
or!=
GREATER THAN
or>
GREATER THAN OR EQUAL
or>=
LESS THAN
or<
LESS THAN OR EQUAL
or<=
IN
NOT IN
MATCHES
or~
DOES NOT MATCH
or!~
IS
IS NOT