[Bug 18985] New: SQL reports 'Last edit' and 'Last run' columns sort alphabetically, not chronologically
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18985 Bug ID: 18985 Summary: SQL reports 'Last edit' and 'Last run' columns sort alphabetically, not chronologically Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Reports Assignee: koha-bugs@lists.koha-community.org Reporter: nick@bywatersolutions.com QA Contact: testopia@bugs.koha-community.org Depends on: 14365 To recreate: Edit and run some reports and then modify the last edited/run dates to be: 7/24/2017 12:12:12 7/25/2016 12:12:12 7/26/2017 12:12:12 Sort by each column and note they will sort in the order above instead of the expected: 7/25/2016 12:12:12 7/24/2017 12:12:12 7/26/2017 12:12:12 Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14365 [Bug 14365] SQL Reports Last Edit Date column -- 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=18985 Marc Véron <veron@veron.ch> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |veron@veron.ch --- Comment #1 from Marc Véron <veron@veron.ch> --- Do we have the same with other dates in data tables as well? -- 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=18985 Owen Leonard <oleonard@myacpl.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Assignee|koha-bugs@lists.koha-commun |oleonard@myacpl.org |ity.org | Severity|enhancement |normal Status|NEW |ASSIGNED -- 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=18985 Owen Leonard <oleonard@myacpl.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Patch complexity|--- |Trivial patch Status|ASSIGNED |Needs Signoff -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18985 --- Comment #2 from Owen Leonard <oleonard@myacpl.org> --- Created attachment 65423 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=65423&action=edit Bug 18985 - SQL reports 'Last edit' and 'Last run' columns sort alphabetically, not chronologically This patch alters the DataTables configuration of the SQL reports list so that date columns are identified via class rather than position. To test, apply the patch and go to Reports -> Use saved. Test the re-ordering of the creation date, last edit, and last run columns. Each should sort correctly based on the date. -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18985 --- Comment #3 from Marc Véron <veron@veron.ch> --- (In reply to Marc Véron from comment #1)
Do we have the same with other dates in data tables as well?
Virtual shelves results (lists) have a 'Date added' column that is not sortable. -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18985 Marc Véron <veron@veron.ch> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #65423|0 |1 is obsolete| | --- Comment #4 from Marc Véron <veron@veron.ch> --- Created attachment 65500 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=65500&action=edit Bug 18985 - SQL reports 'Last edit' and 'Last run' columns sort alphabetically, not chronologically This patch alters the DataTables configuration of the SQL reports list so that date columns are identified via class rather than position. To test, apply the patch and go to Reports -> Use saved. Test the re-ordering of the creation date, last edit, and last run columns. Each should sort correctly based on the date. Signed-off-by: Marc Véron <veron@veron.ch> -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18985 Marc Véron <veron@veron.ch> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Needs Signoff |Signed Off -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18985 Marc Véron <veron@veron.ch> changed: What |Removed |Added ---------------------------------------------------------------------------- See Also| |https://bugs.koha-community | |.org/bugzilla3/show_bug.cgi | |?id=19039 -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18985 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Signed Off |Passed QA -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18985 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #65500|0 |1 is obsolete| | --- Comment #5 from Jonathan Druart <jonathan.druart@bugs.koha-community.org> --- Created attachment 65849 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=65849&action=edit Bug 18985 - SQL reports 'Last edit' and 'Last run' columns sort alphabetically, not chronologically This patch alters the DataTables configuration of the SQL reports list so that date columns are identified via class rather than position. To test, apply the patch and go to Reports -> Use saved. Test the re-ordering of the creation date, last edit, and last run columns. Each should sort correctly based on the date. Signed-off-by: Marc Véron <veron@veron.ch> Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org> -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18985 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Passed QA |Pushed to Master --- Comment #6 from Jonathan Druart <jonathan.druart@bugs.koha-community.org> --- Pushed to master for 17.11, thanks to everybody involved! -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18985 Fridolin SOMERS <fridolin.somers@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |fridolin.somers@biblibre.co | |m Status|Pushed to Master |Pushed to Stable --- Comment #7 from Fridolin SOMERS <fridolin.somers@biblibre.com> --- Pushed to 17.05.x, will be in 17.05.05. -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18985 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |katrin.fischer@bsz-bw.de Status|Pushed to Stable |RESOLVED Resolution|--- |FIXED --- Comment #8 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- There is no 'Last Run' in 16.11.x as this is a 17.05 feature. Also no 'Last edit'. -- You are receiving this mail because: You are watching all bug changes.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org