Functions

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:

•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.

space(number)

return count of spaces. Use this to create empty fields

Example:

item("RM")?$select ItemCode,space(10) as myUdfField

 

This return item code and an empty field with the name "myUdfField"

object

 

Use this,  if you want to save JSON object information in this empty field
Different to String field: In String field the JSON result will be saved only in "...JSON...", but this is a string and not JSON.

 

Example:

in resultSet "b" we've field attribute

and we want to save the result of other entity as json

 

let attrib=bsl.get("ItemBatchAttributes?$select=BatchAttributeCode,Description,Mandatory,InputType&$filter=ItemCode eq :itemCode").toString();

 

b.attributes=attrib.toString();

this return 

"attributes":"[\"Code\":\"Test\"]";

 
if field is type "object" then the result is

"attributes":["Code":"Test"];

 

Example:

 

#jbs
let itemCode="RM_B";
let distNumber="test";
let batchInfo=bsl.get("BatchNumber?$select=Batch,Version,BatchAttribute1,BatchAttribute2,AdmissionDate,ManufacturingDate,\
ExpirationDate,Details,Status,0 as OnHand,space(1) as BinLocation,space(1) as RFID,object() as attributes\
&$filter=ItemCode eq :itemCode  and Batch eq :distNumber");
 
if (batchInfo.rowcount()==0) batchInfo.insertrow(0);
// Save Attributes from this Item in object field "attributes"
batchInfo.attributes=bsl.get("ItemBatchAttributes?$select=BatchAttributeCode,Description,Mandatory,InputType&$filter=ItemCode eq :itemCode").toString();
alert(batchInfo);

boolean(value)

This return a boolean value in the resultSet object

Example   $select=boolean(false)  

 

In datastore you see value 0. If you export this to json, it return false