servertime, devicetime and fixtime

Can I use an external application that queries the traccar database, which of these fields represents the correct order in which the positions were recorded on the device?

I was using the devicetime field, but I started to get some errors in the chronological order of the positions when the tracker loses the GPS or m2m operator signal. displayed represent the correct order of facts based on lat, long.

Both device time and fix time should be in the right order.

Sorted by devicetime brings me in the wrong geolocation order:

Already ordering by fixtime, brings me the path in the correct order that the vehicle actually did:

This is a position that was sent late to the server due to loss of gps or m2m signal.

In general we use the fix time for all reports because it should match the location.

Thank you, I will update my query program to use the fix time field from now on!