This simplified use of the SQL syntax only specifies what should be returned.
The system then creates the following syntax:
select <your script> from "BEAS_DUMMY"
Example: Input: 3.5 * 4
It is executed: select 3.5 * 4 from "BEAS_DUMMY"
If information of a product configurator parameter is required, enclose the parameter in square brackets.
Example: [sofa_width] * 4
If the width is 300, following is executed: select 300 * 4 from "BEAS_DUMMY"
Note:
Since different country settings of the database or Windows system can cause issues with decimal numbers and date definitions, these must be used with the parameters/set-objects (similar to BeasScript) formatting Beas 9.2 PL: 05 (5.13).
SQL conversions can be used for:
numeric values [value,num] or date [date,dbdate] or string [stringparameter,dbstring]
Example:
[sofa_length,num] * 4 (with sofa_length: 200,5)
You can insert complete sql statements
Example: Return UDF-Field: U_MaterialColor
select "U_MaterialColor" from "OITM" where "ItemCode"=[my_itemcode,dbstring]
Important: Do not forget the quotation marks at placeholder if it is about a reference.
Example: Visibility Rule
A selection element of a list should only be displayed if the parameter "cushions" has the content "Y":
[cushions] = 'Y'
Example: Assign a value (or text) to a Set object
If the content of the parameter "headrest" has the content "Y" then assign "Y", otherwise "N":
case when [headrest]='Y' then 'Y' else 'N' end
HANA
You must always define a table in HANA.
Without defining a table, the system automatically inserts the keyword ' from "BEAS_DUMMY" '
If you work with complete SQL statements or with sub-select commands, you must define the Table.
Note: BeasScript placeholder ( <placeholder>) is not supported.
Examples:
sofa_width=300, numeric value
Example
|
Executed SQL command
|
[sofa_width] * 4
|
select 300 * 4 from "BEAS_DUMMY"
|
select [sofa_width] * 4
|
select 300 * 4 from "BEAS_DUMMY"
|
select "ItemName" from "OITM" where "ItemCode"='1111'
|
select "ItemName" from "OITM" where "ItemCode"='1111'
the system find the keyword "from" inside the sql statement and don't insert the "BEAS_DUMMY"
|
(select "ItemName" from "OITM" where "ItemCode"='1111') || 'hello'
|
select (select "ItemName" from "OITM" where "ItemCode"='1111') || 'hello'
Open bracket without closing bracket creates a sub-select command.
The system finds the keyword "from" inside the sql statement and does not insert the "BEAS_DUMMY"
This is working in MSSQL, but not in HANA, because we miss table "BEAS_DUMMY" outside the sub-select command.
|
select "ItemName" || 'hello' from "OITM" where "ItemCode"='1111'
|
select "ItemName" || 'hello' from "OITM" where "ItemCode"='1111'
It is working in Hana and MSSQL.
|
|