OCPM Order events of the same type I created a ‘Status change’ event in OCPM and I can’t establish an order for the events that have the same timestamp. The script looks like this (I simplified it to be easier to understand):SELECT DISTINCT 'MeldungGeneralEvent_' || meldung_objects.QMNUM || JCDS.STAT || JCDS.UDATE || JCDS.UTIME AS "ID", 'Meldung_' || meldung_objects.QMNUM AS "Meldung", 'Meldung Status Changed' AS ActivityName, COALESCE(SS.TXT04, US.TXT04) AS ActivityStatus, CAST(JCDS.UDATE AS DATE) + CAST(JCDS.UTIME AS TIME) AS "Time", CASE WHEN COALESCE(SS.TXT04, US.TXT04) LIKE '%EGPR%' THEN 33 WHEN COALESCE(SS.TXT04, US.TXT04) LIKE '%MMAB%' THEN 34 ELSE 32 END AS Sorting,FROM meldung_objectsTo give an example, I select only the activities for Meldung number “748291035”:The way I want my activities to be ordered is like this:Time Sorting Alphabetical order for ActivityStatusSo the order to be: MOFN, UGPR, MAUF, MIAR, EGPR, MMABFirst, I tried to use the Sorting column in the Knowledge Model, where I
