Supported SQL Functions

Query Builder allows applying expression and aggregation functions to the result fields when Picking Data to Query. These functions are type-specific, so for certain field types certain functions are available. Supported functions are listed below.

Field type

Supported functions

 

Fields with string data

Aggregation Functions

Count - returns the number of records in a group.

Fields with numeric data

Aggregation Functions

Avg - returns average value of non-NULL values in a group.
Count - returns the number of records in a group.
Max -  returns the maximum value in the group,
Min -  returns the minimal value in the group.
Sum - returns the sum of all non-NULL values in a group.

Boolean fields

Aggregation Functions

Count - returns the number of records in a group.

Datetime fields

Aggregation Functions

Count - returns the number of records in a group.

Expression Functions

Day - returns the date portion of a datetime value.
Month - returns the month and year of a datetime value.
Year - returns the year portion of a datetime value.
Day of Month - returns only the day portion of a datetime value - the number of a day in a month.
Month of Year - returns only the month portion of a datetime value - the number of a month.

Fields with binary data

No functions supported.


All columns/All columns from a table (* or table_name.* )

Aggregation Functions

Count - returns the number of records in a group.