Insert Timestamp field may be used to reliably sort the system log?

G24
Kilo Sage

So apparently you can add a field of type "Insert Timestamp" to the System Log, and that will give us a reliable way to sort messages IN THE ORDER in which they were logged.  Very useful for script debugging!

 

Example:

Log 10 messages, one right after another.

AA.png

Try sorting by "Created".  This does not work.  Messages order is 'random' because the Create Date/Time is not granular enough:

CC.png

Now try sorting by the new, magical "Insert Timestamp" field.  This seems to work!

DD.png

1)  Any issues with adding one of these "Insert Timestamp" fields to our System Log tables?

2)  Where is the product documentation on this "Insert Timestamp" field type???

3)  Why isn't this included as a field on the System Log table by default?

Thanks!

0 REPLIES 0