intellij-dynamodb icon indicating copy to clipboard operation
intellij-dynamodb copied to clipboard

Column sorting when clicking on column heading doesn't order ISO datetime strings

Open rcoundon opened this issue 8 months ago • 0 comments

Describe the bug Column sorting when clicking on column heading doesn't order rows correctly when the rows are using an ISO formatted date time.

Steps to reproduce When clicking on the heading for a column holding this data following a query:

2025-01-08T15:30:04.767Z 2025-01-13T15:10:06.590Z 2025-01-15T17:00:06.682Z 2025-01-15T15:55:06.601Z 2025-03-05T21:45:48.034Z 2025-03-05T21:40:48.219Z 2025-03-05T21:40:48.197Z 2025-03-05T20:10:48.180Z 2025-03-05T20:05:48.580Z 2025-03-05T19:25:50.130Z 2025-03-05T19:10:47.886Z 2025-03-05T18:55:47.931Z 2025-03-05T18:35:47.977Z 2025-03-05T18:25:50.325Z 2025-03-05T17:45:48.132Z 2025-03-05T16:40:48.570Z

No noticeable ordering takes place

Expected behavior I'd expect a lexicographical sort on the text in the field which works for ordering in ISO dates

Environment information:

  • OS:
  • IDE version:
  • plugin version:

rcoundon avatar Mar 20 '25 09:03 rcoundon