[Bug 18396] New: UK format dates not sorting correctly
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18396 Bug ID: 18396 Summary: UK format dates not sorting correctly Change sponsored?: --- Product: Koha Version: 16.05 Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Staff Client Assignee: koha-bugs@lists.koha-community.org Reporter: david.roberts@ptfs-europe.com QA Contact: testopia@bugs.koha-community.org CC: gmcharlt@gmail.com Created attachment 61956 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=61956&action=edit Screenshot showing UK date sorting problem When you view a user with a large number of checkouts, and you sort the checkouts by date issued, if the system uses UK date format (DD/MM/YYYY) the sorting doesn't working correctly - for example, you might see: 02/02/2017 03/03/2017 08/02/2017 10/01/2017 16/12/2016 instead of the correct order, which would be: 16/12/2016 10/01/2017 02/02/2017 08/02/2017 03/03/2017 See attached screenshot for a real example. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18396 Ray Delahunty <r.delahunty@arts.ac.uk> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |r.delahunty@arts.ac.uk -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18396 --- Comment #1 from Owen Leonard <oleonard@myacpl.org> --- My favorite method of avoiding date parsing nightmares when sorting is to use the "title-string" option for DataTables. \koha-tmpl\intranet-tmpl\prog\en\modules\admin\currency.tt: 30 "columnDefs": [ 31 { "aTargets": [ -1 ], "bSortable": false, "bSearchable": false }, 32: { "sType": "title-string", "aTargets" : [ "title-string" ] } 33 ], 34 }, columns_settings ); .. 208 <th>Symbol</th> 209 <th>ISO code</th> 210: <th class="title-string">Last updated</th> 211 <th>Active</th> 212 <th>Archived</th> .. 223 <td><span title="[% currency.timestamp %]">[% currency.timestamp | $KohaDates %]</span></td> I don't know if that solution would work with the checkouts table. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18396 Owen Leonard <oleonard@myacpl.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Severity|enhancement |normal -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18396 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Resolution|--- |DUPLICATE CC| |katrin.fischer@bsz-bw.de Status|NEW |RESOLVED --- Comment #2 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- The checkouts table checkout date sorting issue was fixed by bug 21562. *** This bug has been marked as a duplicate of bug 21562 *** -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org