List with timestamps unsorted

LabKey Support Forum (Inactive)
List with timestamps unsorted eva pujadas  2020-08-06 08:43
Status: Active
 
Hello Chet,

Thank you very much for checking this issue.

> What version of Labkey are you running?
This happens in both versions 19.3.7 and 19.3.10

> Were you hoping that the order of the primary key would also represent the order of the date/time column? As the primary key increases so does the date/time.
Exactly, that was a requirement

I've seen in your screenshot that the number columns were probably imported as text, since some of the records contain a "?" as value. To reproduce the error, a missing value indicator with value "?" needs to be created first. Afterwards, import the data file with following column data types: DateTime, Double, Integer, Integer, Integer (default behavior) (see screenshot).
Depending on the instance of LabKey server used, the error can appear for a key value of 24735, or 82061 and 19897 and 21340 (see screenshots). It seems to be somehow variable, although I do not know on what it depends.

Thanks once more and best regards,
Eva