Functions

concat(any,any[,...)

Allows concatenation of two or more properties.

The properties can be:

•Number

•String

•NULL fields

•Boolean

•Date, DateTime

•"text"

•Numeric information as 1.234

•Placeholder

Functions are not allowed.

Example

Item?$select concat(ItemCode," ",IteName," Stock: ",onhand)

Note: HANA does not support concatenation of more then 2 strings or combination from different field types. The Beas Service Layer generates SQL HANA syntax automatically, which make this possible.

Example

With 3 parameters, the system generate the following syntax in the HANA database:

conact(to_alphanum(x),concat(to_alphanum(y),to_alphanum(z))

left(field name,number)

Return number chars from the string argument (example: field name) from the left side.

Example

Item("RM")?$select=left(ItemName,5)

right(field name,number)

Return number chars from the string argument (example: field name) from the right side.

Example

Item("RM")?$select=right(ItemName,5)

sum(field name)

Summarize the field. Same as SQL sum()

Note: if you have additional fields, you must work with $groupby.