Summary | Guide | Keywords | Operators | Related Articles
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.
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 by
OR- Displays a record if and one of the conditions separated by
NOT- Displays a record if the stated conditions are
EMPTY- Displays a record if the requested value
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:
GREATER THAN OR EQUALor
LESS THAN OR EQUALor
DOES NOT MATCHor