ACTIVITY_COLUMN
Description
ACTIVITY_COLUMN
allows to refer the activity column of an activity table in the data model without using the exact column name.
Syntax
ACTIVITY_COLUMN ( [ expression ] )
When an expression that involves a column of an activity table is passed as an argument, the activity column of that activity table is referenced.
When no argument is passed, the activity column of the default activity table is referenced.
When a table reference is passed as an argument, the activity 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 ACTIVITY column of the related activity table: | ||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
|
[2] In this example, the data model contains one activity table. By passing no arguments to the | ||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
|
[3] In this example, MERGE_EVENTLOG is used to combine two activity tables into one. We can then use | ||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||
|
[4] In this example, the data model contains one activity table. Using a table reference as the input expression, we refer to the ACTIVITY column of the related activity table: | ||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
|