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 |
||