Element Details: Sql+Calculated+Column+
 Back


Available in: Logi Info Source code name: SqlCalculatedColumn

Active SQL SqlCalculatedColumn adds a new column in the DataLayer from other values in the same row, or from other token values. The column can be used like any other column.

Set the ID to the name of the new column.

Example: Suppose you have an Order table with Price and Qty. You could create a Total column with a Formula attribute like:

@Data.Price~ * @Data.Qty~

Element Group:Add and Replace Columns



ATTRIBUTES

Click attribute Name to drill down for more information.

NamePossible ValuesDescription
ID
UserDefined
(Required) The ID attribute is a pervasive attribute that uniquely identifies an element within a definition file. The ID needs to be a unique value within the definition.
SqlFormula
UserDefined
(Required) A SQL formula that the database system will recognize.



PARENT ELEMENTS

Click element to drill down for more information.

DataLayer.ActiveSQL Sql Query


CHILD ELEMENTS

Click element to drill down for more information.



 Back to top