Process reference
CTIVITY_COLUMN
Description: Returns the column in the data model that represents the activity name.
Syntax: ACTIVITY_COLUMN ( activity_table.activity )
Example:
TABLE( ACTIVITY_COLUMN("Activities"."Activity") )
CALC_THROUGHPUT
Description: Calculates the throughput time between two specified activities in a case.
Syntax: CALC_THROUGHPUT ( begin_event_specifier TO end_event_specifier , timestamps [ , activity_table.string_column ] )
Example:
TABLE( CALC_THROUGHPUT(FIRST_OCCURRENCE['Create Order'] TO LAST_OCCURRENCE['Goods Issue'], REMAP_TIMESTAMPS("Activities"."Eventtime", SECONDS)) AS 'Throughput (s)')
CASE_ID_COLUMN
Description: Returns the column representing the case identifier in the event log.
Syntax: CASE_ID_COLUMN ( activity_table.case_id )
Example:
TABLE( CASE_ID_COLUMN("Activities"."CaseId") )
END_TIMESTAMP_COLUMN
Description: Returns the column representing the end timestamp of events.
Syntax: END_TIMESTAMP_COLUMN ( activity_table.end_timestamp )
Example:
TABLE( END_TIMESTAMP_COLUMN("Activities"."EndTime") )
TIMESTAMP_COLUMN
Description: Returns the main timestamp column used to order events in the event log.
Syntax: TIMESTAMP_COLUMN ( activity_table.timestamp )
Example:
TABLE( TIMESTAMP_COLUMN("Activities"."Eventtime") )
VARIANT
Description: Returns the variant identifier representing the sequence of activities executed in a case.
Syntax: VARIANT ( activity_table.activity )
Example:
TABLE( VARIANT("Activities"."Activity") AS "Variant" )