Skip to main content

PQL47 (PQL Function Library - CPM 4.7)

CASE_ID_COLUMN

Applies to: CELONIS 4.7

Description

CASE_ID_COLUMN allows to refer the case column of an activity table in the data model without using the exact column name.

Syntax
CASE_ID_COLUMN ( [ expression ] )

  • When an expression that involves a column of an activity table is passed as an argument, the case column of that activity table is referenced.

  • When no argument is passed, the case column of the default 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 CASE_ID column of the related activity table.

Query

Column1

CASE_ID_COLUMN ( "Activities"."ACTIVITY" )

Input

Output

Activities

CASE_ID : STRING

ACTIVITY : STRING

TIMESTAMP : DATE

'1'

'A'

Wed Jan 01 2020 00:00:00.000

'1'

'B'

Thu Jan 02 2020 00:00:00.000

'2'

'A'

Wed Jan 01 2020 00:00:00.000

'2'

'C'

Thu Jan 02 2020 00:00:00.000

'3'

'D'

Wed Jan 01 2020 00:00:00.000

Result

Column1 : STRING

'1'

'1'

'2'

'2'

'3'

[2] In this example, the data model contains one activity table. By passing no arguments to the CASE_ID_COLUMN, function, we refer to the CASE_ID column of the default activity table.

Query

Column1

CASE_ID_COLUMN ( )

Input

Output

Activities

CASE_ID : STRING

ACTIVITY : STRING

TIMESTAMP : DATE

'1'

'A'

Wed Jan 01 2020 00:00:00.000

'1'

'B'

Thu Jan 02 2020 00:00:00.000

'2'

'A'

Wed Jan 01 2020 00:00:00.000

'2'

'C'

Thu Jan 02 2020 00:00:00.000

'3'

'D'

Wed Jan 01 2020 00:00:00.000

Result

Column1 : STRING

'1'

'1'

'2'

'2'

'3'