Process Reference
Description
Process reference functions can be used to reference the case table or configured activity columns based on an expression.
These operators are useful when working with data models with multiple activity and case tables. For example, they can be used to reference the corresponding case table for every activity table in the data model, or to reference standard activity table columns from a combined activity table generated with MERGE_EVENTLOG.
Process table reference
CASE_TABLE returns a reference to the case table corresponding to the provided activity table column. If no argument is provided, the default case table is referenced.
ACTIVITY_TABLE returns a reference to the activity table corresponding to the provided activity table column. If no argument is provided, the default activity table is referenced.
Activity table column reference
Those functions allow to refer to the essential columns of activity tables in the data model without using the exact activity table or column names. If an activity table column is passed as an argument, the respective column of the corresponding activity table is referenced. If no argument is provided, the respective column of the default activity table is referenced. We provide the following functions for each of the essential activity table columns:
ACTIVITY_COLUMN returns a reference to the activity column.
CASE_ID_COLUMN returns a reference to the case column.
TIMESTAMP_COLUMN returns a reference to the timestamp column.
END_TIMESTAMP_COLUMN returns a reference to the end timestamp column. If no end timestamp column is defined, the timestamp column will be returned.