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 |
Related information