ODATA functions
Contents
Note:
Currently a limited number of function calls are supported. Functions are not allowed to be used as parameters.
It is not possible to use function calls inside function calls!
The following functions are supported:
Name |
Description |
||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
concat(any,any[,...) |
Allows concatenation of two or more properties. The properties can be:
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 left side Example Item("RM")?$select=left(ItemName,5) |
||||||||||||||
right(field name,number) |
Return number chars from the string argument (example: field name) from right side Example Item("RM")?$select=right(ItemName,5) |
||||||||||||||
sum(field name) |
Summarize the field. Same as SQL sum() Note: if you've additional fields, you must work with $groupby Beas 2020.09 |