Applies to: CELONIS 4.0 CELONIS 4.2 CELONIS 4.3 CELONIS 4.4
Description
PROCESS EQUALS matches the variants of a process based on simple expressions. PROCESS EQUALS is less powerful than MATCH_PROCESS but it is also simpler to use.
Syntax
PROCESS [ NOT ] equals [ start ] activity ( to activity )* [ end ]
- equals: EQUALS | #
- start: START | ^ (The case has to match from the start)
- end: END | $ (The case has to match till the end)
- to: TO | ->
- activity: ANY | * | single_activity | grouped_activity
- single_activity: [LIKE] activity (Activity name. LIKE allows you to use wildcards in your activity name)
- grouped_activity: single_activity (, single_activity )*
Examples
PROCESS EQUALS to filter down to cases where activity 'A' is directly followed by 'B'. Where in the case the activity 'A' is followed by 'B' doesn't matter in this case.
Filter
FILTER PROCESS EQUALS 'A' to 'B'
Column1
"Table1"."CASE_ID"
Column2
"Table1"."ACTIVITY"
ANY or short * is placeholder for no activity or an arbitrary number of activities. Therefore in this example all three cases are in the result.
Filter
FILTER PROCESS EQUALS 'A' to ANY to 'C'
Column1
"Table1"."CASE_ID"
Column2
"Table1"."ACTIVITY"
Table1
CASE_ID : STRING | ACTIVITY : STRING | TIMESTAMP : DATE |
---|---|---|
'1' | 'A' | Sun Jan 01 2017 13:00:00.000 |
'1' | 'C' | Sun Jan 01 2017 13:02:00.000 |
'2' | 'A' | Sun Jan 01 2017 13:00:00.000 |
'2' | 'B' | Sun Jan 01 2017 13:02:00.000 |
'2' | 'C' | Sun Jan 01 2017 13:04:00.000 |
'3' | 'A' | Sun Jan 01 2017 13:00:00.000 |
'3' | 'B' | Sun Jan 01 2017 13:02:00.000 |
'3' | 'B' | Sun Jan 01 2017 13:04:00.000 |
'3' | 'C' | Sun Jan 01 2017 13:06:00.000 |
With END the given pattern has to match directly before the end of the case.
Filter
FILTER PROCESS EQUALS 'A' END
Column1
"Table1"."CASE_ID"
Column2
"Table1"."ACTIVITY"
With START the given pattern has to match directly from the case start.
Filter
FILTER PROCESS EQUALS START 'A'
Column1
"Table1"."CASE_ID"
Column2
"Table1"."ACTIVITY"
It is also possible to use a shorter syntax. The example query is identical to PROCESS EQUALS START 'A' TO 'B' END.
Filter
FILTER PROCESS # ^ 'A' -> 'B' $
Column1
"Table1"."CASE_ID"
Column2
"Table1"."ACTIVITY"
With LIKE wildcards can be used for the activity names.
Filter
FILTER PROCESS EQUALS START 'A' TO LIKE 'B%' END
Column1
"Table1"."CASE_ID"
Column2
"Table1"."ACTIVITY"
Restricts the result to cases where A isn't directly followed by C.
Filter
FILTER PROCESS NOT EQUALS 'A' to 'C'
Column1
"Table1"."CASE_ID"
Column2
"Table1"."ACTIVITY"
Table1
CASE_ID : STRING | ACTIVITY : STRING | TIMESTAMP : DATE |
---|---|---|
'1' | 'A' | Sun Jan 01 2017 13:00:00.000 |
'1' | 'C' | Sun Jan 01 2017 13:02:00.000 |
'2' | 'A' | Sun Jan 01 2017 13:00:00.000 |
'2' | 'B' | Sun Jan 01 2017 13:02:00.000 |
'2' | 'C' | Sun Jan 01 2017 13:04:00.000 |
'3' | 'A' | Sun Jan 01 2017 13:00:00.000 |
'3' | 'B' | Sun Jan 01 2017 13:02:00.000 |
'3' | 'B' | Sun Jan 01 2017 13:04:00.000 |
'3' | 'C' | Sun Jan 01 2017 13:06:00.000 |