Skip to main content

PQL47 (PQL Function Library - CPM 4.7)

Process reference

Applies to: CELONIS 4.7


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/case tables.

Case 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 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: