Query language

Corteza implements an SQL-like syntax for querying and sorting records.

Querying

The general template for constructing a query looks like this:

FIELD OPERATOR VALUE [AND|OR FIELD OPERATOR VALUE [...]]

For the following examples, let us assume that we have a module named test with the following fields:

To query for records with zero quantity or zero price:

quantity = 0 or price = zero

To query all visible records starting with the letter "a":

visible AND name LIKE 'a%'

Equal

Not equal

Less then

Less or equal then

Greater then

Greater or equal then

Matches pattern

Does not match the pattern

When matching patterns, use _ to represent a single character; use % to represent zero, one, or multiple characters.

Addition

Subtraction

Multiplication

Division

The general template for constructing a sort looks like this:

FIELD[ DIRECTION][, FIELD[ DIRECTION] [...]]

Supported directions:

ASC: sort in ascending order, lower values first (NULL values are first). This is the default sort if no DIRECTION is specified.
DESC: sort in ascending order, lower values last (NULL values are last).

For the following examples, let us assume that we have a module named test with the following fields:

To order records, descending by price and ascending by quantity:

price DESC, quantity

Returns quarter from the given timestamp.

Returns year from the given timestamp.

The function returns the date formatted by the provided format.

DevNote add a format reference.

Returns date from the given timestamp.