OQL Keywords and Operators

Follow

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 by AND are TRUE
  • OR - Displays a record if and one of the conditions separated by OR is TRUE
  • NOT - Displays a record if the stated conditions are NOT TRUE
  • EMPTY - Displays a record if the requested value IS 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