From c9516a6c191cfe408e56411c78e3e311d326ce12 Mon Sep 17 00:00:00 2001 From: Martin Renvoize Date: Wed, 8 May 2019 19:13:46 +0100 Subject: [PATCH] Bug 22357: (RMaint follow-up) Mana does not exist in 18.11.x Signed-off-by: Martin Renvoize --- C4/Reports/Guided.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/C4/Reports/Guided.pm b/C4/Reports/Guided.pm index 8ff7c26073..57e5756930 100644 --- a/C4/Reports/Guided.pm +++ b/C4/Reports/Guided.pm @@ -687,7 +687,7 @@ sub get_saved_reports { } } $query .= " WHERE ".join( " AND ", map "($_)", @cond ) if @cond; - $query .= " GROUP BY s.id, s.borrowernumber, s.date_created, s.last_modified, s.savedsql, s.last_run, s.report_name, s.type, s.notes, s.cache_expiry, s.public, s.report_area, s.report_group, s.report_subgroup, s.mana_id, av_g.lib, av_sg.lib, b.firstname, b.surname"; + $query .= " GROUP BY s.id, s.borrowernumber, s.date_created, s.last_modified, s.savedsql, s.last_run, s.report_name, s.type, s.notes, s.cache_expiry, s.public, s.report_area, s.report_group, s.report_subgroup, av_g.lib, av_sg.lib, b.firstname, b.surname"; $query .= " ORDER by date_created"; my $result = $dbh->selectall_arrayref($query, {Slice => {}}, @args); -- 2.39.2