[Koha-bugs] [Bug 31331] OPAC suggestions table doesn't sort correctly by suggeestiondate in some dateformats

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31331

--- Comment #2 from Lucas Gass <lucas at bywatersolutions.com> ---
Created attachment 138919
  -->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=138919&action=edit
Bug 31331: Add data-order attribute for better sorting of dates

To test:
1. I used the following suggestiondates:

MariaDB [koha_kohadev]> select suggesteddate from suggestions;
+---------------+
| suggesteddate |
+---------------+
| 2022-01-03    |
| 2022-08-09    |
| 2022-02-22    |
| 2021-01-21    |
+---------------+

2. Set the dateformat system preference to 'mm/dd/yyyy'.
3. Try sorting the suggestion table by date, ascending and descending, it is
not right.
4. Apply patch
5. Try sorting by date again, ascending and descending, it should now sort
correctly.

-- 
You are receiving this mail because:
You are watching all bug changes.