Follow

OQL Keywords and Operators

Summary | Guide | Keywords | Operators | Related Articles

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.

Back to top

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

Back to top

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

Back to top

Related Articles

Quick Search

Search Overview

Saving/Deleting a Search View

Back to top

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request