Skip to content

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

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Open
rcoundon opened this issue Mar 20, 2025 · 0 comments
Labels
bug Something isn't working

Comments

@rcoundon
Copy link

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 rcoundon added the bug Something isn't working label Mar 20, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

1 participant