Application management : Tools : Data Aggregation : Configuring Data aggregation properties : Aggregation properties BO for ReportSX and CalculateSX : SQL for Data level : Data level
Data level
Based on SQL queries, specific fields on the Data level can be filled.
Key
Value example / Info
Extension
Field.<FieldN­ame>.<TYPE>
Field.FreeString41.STRING= select Free30 from OBJALG where syscode = &PropertyRef& or Field.FreeString41.STRING= { select Free30 from OBJALG where syscode = &PropertyRef& } Field.FreeDecimal1.­DECIMAL= select m2bvo from OBJALG where syscode = &PropertyRef& or Field.FreeDecimal1.­DECIMAL= { select m2bvo from OBJALG where syscode = &PropertyRef& } Field.FreeDecimal10.­DECIMAL; Field.FreeDecimal11.­DECIMAL =select Kadoppvl, Free25 from OBJALG where syscode = &PropertyRef& or Field.FreeDecimal10.­DECIMAL; Field.FreeDecimal11.­DECIMAL = { select Kadoppvl, Free25 from OBJALG where syscode = &PropertyRef& }
Info
• Fields to be populated. Format: Field.­<FieldName>. <TYPE>­=<SQL-select statement>
Available types are:
◦ STRING
◦ INTEGER
◦ DECIMAL
◦ REFERENCE.INTEGER and REFERENCE.STRING
◦ DATE / DATETIME
◦ CODESCODE­NAME
◦ CODESNAME
◦ DATETIME_PROPERTY
◦ DATETIME_TRANSACTION
• If more than one field is to be updated, then separate them with a semicolon (;) as shown in the last example.
• All the variables in the query (for example: &PropertyRef&) should be defined.
• All the variables should start and end with an “&” symbol
• SQL string can be given as one line with no carriage returns or can be divided over more lines. In the last method the query must start with { character and end with }
ReportSX/ CalculateSX