From e88a5b790d7de70b7325330be09cc81e938a1e2e Mon Sep 17 00:00:00 2001 From: Owen Leonard Date: Tue, 1 Aug 2017 17:07:33 +0000 Subject: [PATCH] Bug 18985 - SQL reports 'Last edit' and 'Last run' columns sort alphabetically, not chronologically MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit 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 Signed-off-by: Jonathan Druart --- .../prog/en/modules/reports/guided_reports_start.tt | 12 +++++------- 1 file changed, 5 insertions(+), 7 deletions(-) diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/reports/guided_reports_start.tt b/koha-tmpl/intranet-tmpl/prog/en/modules/reports/guided_reports_start.tt index 4c3b47e64d..5902b92cfe 100644 --- a/koha-tmpl/intranet-tmpl/prog/en/modules/reports/guided_reports_start.tt +++ b/koha-tmpl/intranet-tmpl/prog/en/modules/reports/guided_reports_start.tt @@ -101,10 +101,8 @@ $("#delColumn").on("click",function(){ 'aoColumnDefs': [ { 'bSortable': false, 'bSearchable':false, 'aTargets': [0, -1] }, { 'bSearchable': false, 'aTargets': [3] }, - { "aTargets": [ 1, 2 ], "sType": "natural" } - ], - "aoColumns": [ - null,null,null,null,null,null,null,null,{ "sType": "title-string" },null,null,null,[% IF (usecache) %]null,[% END %]null,null[% IF has_obsolete_reports %],null[% END %] + { "aTargets": [ 1, 2 ], "sType": "natural" }, + { "sType": "title-string", "aTargets" : [ "title-string" ] } ], 'oLanguage': { 'sZeroRecords': _("No matching reports found") @@ -387,9 +385,9 @@ canned reports and writing custom SQL reports.

Subgroup Notes Author - Creation date - Last edit - Last run + Creation date + Last edit + Last run Public [% IF (usecache) %] Cache expiry (seconds) [% END %] Saved results -- 2.11.0