Built-In Methods

Last updated 13/03/2026

Aggregate Functions

An aggregate function performs a calculation on a set of values and returns a single result set. These functions are commonly used in queries to summarize data, such as totals, averages, or counts.

In Five's Query Builder, several built-in aggregate functions can be applied to fields by selecting them in the Modifier field:

Function	Return Value
Minimum	The smallest value found in a column
Maximum	The largest value found in a column
Count	The number of rows in a set of results
Sum	The total of all values in a numerical column
Average	The average value of a numerical column

Statements

Five's Query Builder also provides the

GROUP BY

statement, which can also be selected in the Modifier field.

GROUP BY

, groups rows that share the same values in one or more columns. This allows aggregate functions to be calculated for each group of records rather than for the entire dataset.

GROUP BY

is a query clause used to organize data into groups, enabling aggregate functions to return a result for each group.

Logical Operators

Criteria added in the Query Builder can be combined using logical operators to refine and control how records are filtered. Logical operators allow multiple conditions to be evaluated together when determining which records should be returned by a query.

The available operators are

AND

,

OR

, and NOT, represented as

<>

.

The

AND

operator is used when all conditions must be true for a record to be included in the results. The

AND

operator can be used within a single field by typing

AND

between conditions. When criteria is applied across multiple fields, the Query Builder automatically treats them as

AND

conditions, so there is no need to explicitly type

AND

.

The

OR

operator is used when any of the conditions can be true. A record will be returned if it satisfies at least one of the conditions connected with

OR

. In the Query Builder, an

OR

condition can be added by clicking the ADD OR button, which allows additional alternative criteria to be defined.

The NOT operator is represented as

<>

and is used to exclude records that match a condition. It returns records where the specified condition is not true.

Operators

In addition to logical operators, common SQL operators are also supported in the Criteria field. For example, the

LIKE

operator can be used for pattern matching, represented using the

%

wildcard, and the

BETWEEN

operator can be used to filter values that fall within a specified range.