I have to build up a own event log on SQL database. This worked but I have events with the same timestamp within the same case. So sometimes the event aren't in the right order in the process explorer.

Hi Paul,

The sorting is an additional information that is only relevant in Celonis, and which serves to sort activities having a same timestamp in a specific order.

So basically, at each transformation where you identify an activity, you should add a _SORTING field with a fixed number.

But first things first, you need to add this field to your activity table definition. It is of type Integer:

_SORTING INT,

And then based on the expected happy flow, you give each activity a 'value' to have them sorted out the expected way:

'Create' activity = 10, any 'Change' activity = 20, 'Send' activity = 30 etc...

SQL syntax is quite easy and similar to the activity description you have added in the transformation. For example:

10 AS _SORTING,

Note that it is recommended to use a 2 or 3 digits number to enable adding new activities in between if needed at a later stage.

Also, you can give each activity a dedicated number, or group some activities under one same number. I usually consider 'Change' activities under a same number unless the process contains such activities that can only happen after others, or if I need to use the sorting ID later in the analysis (where it is easier to use an ID than a description)

kind regards

Marc