From fb16189e0bedb6c2c91d778ca842cfca2507018c Mon Sep 17 00:00:00 2001
From: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
Date: Tue, 6 Feb 2018 15:43:09 -0300
Subject: [PATCH] Bug 20144: [sql_modes] Fix GROUP BY clause in Virtualshelves
 search (DT)

Fix for:
'koha_kohadev.vs.shelfname' isn't in GROUP BY

t/db_dependent/Utils/Datatables_Virtualshelves.t

Signed-off-by: Josef Moravec <josef.moravec@gmail.com>
Signed-off-by: Julian Maurice <julian.maurice@biblibre.com>

Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
---
 C4/Utils/DataTables/VirtualShelves.pm | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

diff --git a/C4/Utils/DataTables/VirtualShelves.pm b/C4/Utils/DataTables/VirtualShelves.pm
index 156b68cb23..5a349326b1 100644
--- a/C4/Utils/DataTables/VirtualShelves.pm
+++ b/C4/Utils/DataTables/VirtualShelves.pm
@@ -95,7 +95,8 @@ sub search {
         $limit = "LIMIT $dt_params->{iDisplayStart},$dt_params->{iDisplayLength}";
     }
 
-    my $group_by = " GROUP BY vs.shelfnumber";
+    my $group_by = " GROUP BY vs.shelfnumber, vs.shelfname, vs.owner, vs.category,
+        vs.created_on, vs.lastmodified, bo.surname, bo.firstname, vs.sortfield ";
 
     my $query = join(
         " ",
-- 
2.39.5