I query historical alarm from the journal with system.alarm.queryJournal.
In my case data are stored in MYSQL.
if the alarm is active and cleared in the same second when I sort my result with event time, the chronological order can be wrong because the event timetamp has no millisecond.
The alarm journal table seem to have an incremental id which could be perhaps used to give the chronological order of event but this id is not returned by the system.alarm.queryJournal result ???
system.alarm.queryJournal. return a list of event, but is there a sort order ?
Since mysql 5.6+, DATAETIME(3) enable to store datetime with milliseconds. It will be usefull to update alarm journal creating script for support of millisecond.