Cloud Software Group, Inc. EBX®
Documentation > Developer Guide > SQL in EBX®
Navigation mode Documentation > Developer Guide > SQL in EBX®

# EBX® SQL functions

The following table lists all of the EBX® built-in SQL functions, along with their syntax. Some functions can have optional parameters: they are surrounded by square brackets.

Operator syntax | Description and example(s)
--- | ---
FK_AS_STRING(tableRefValue) | Returns the string representation of a tableRef value. This function cannot be used on aggregated lists. This 1-parameter version of FK_AS_STRING can only be used on unambiguous contexts; in other scenarios, e.g. in certain queries after a UNION or UNNEST, the 3-parameter version must be used (see below). `SELECT e.name FROM employee e WHERE FK_AS_STRING(e.department) = '1' : Smith` `SELECT FK_AS_STRING(e.department) FROM employee e WHERE e.name = 'Smith' : 1`
FK_AS_STRING('referencedDatasetName', 'referencedTableName', tableRefValue) | Returns the string representation of a tableRef value. This function cannot be used on aggregated lists. See QueryBuilder JavaDoc to learn more about the referenced dataset names. `SELECT e.name FROM employee e WHERE FK_AS_STRING('_public', '/root/department', e.department) = '1' : Smith` `SELECT FK_AS_STRING('_public', '/root/department', e.department) FROM employee e WHERE e.name = 'Smith' : 1`

Documentation > Developer Guide > SQL in EBX®