[Koha-bugs] [Bug 31331] New: 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

            Bug ID: 31331
           Summary: OPAC suggestions table doesn't sort correctly by
                    suggeestiondate in some dateformats
 Change sponsored?: ---
           Product: Koha
           Version: master
          Hardware: All
                OS: All
            Status: NEW
          Severity: enhancement
          Priority: P5 - low
         Component: OPAC
          Assignee: oleonard at myacpl.org
          Reporter: lucas at bywatersolutions.com
        QA Contact: testopia at bugs.koha-community.org

To recreate:

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 bu date, ascending and descending, it is
not right.

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