SORTING_COLUMN
Description
SORTING_COLUMN allows to refer the sorting column of an activity table in the data model without using the exact column name.
Syntax
SORTING_COLUMN ( [ expression ] )
When an expression that involves a column of an activity table is passed as an argument, the sorting column of that activity table is referenced.
When no argument is passed, the sorting column of the default activity table is referenced.
When a table reference is passed as an argument, the sorting column of that activity table is referenced.
Examples
[1] In this example, the data model contains one activity table. Using a column reference as the input expression, we refer to the SORTING column of the related activity table: | ||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||
|
[2] In this example, the data model contains one activity table. Using a table reference as the input expression, we refer to the SORTING column of the related activity table: | ||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||
|