Problem

Currently, fields like EventTime are of type VARCHAR2 in the Sentinel Database, because this is how they are sent from the source product.

Therefore fields like this cannot be used for sorting a report.

*The same goes for SENDTIME, TIMEACK, ACKTIME, EARLIESTTIME, STARTTIME, ENDTIME, LATESTTIME

Resolution

Convert EventTime to TimeStamp in order to be able to sort by it (This can only be done for reports based on standard data dictionaries).

See the attached document for the steps to follow.