From 0d6f729b33ff90e686bb7144ed831bf47661b3cd Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Wed, 22 May 2024 09:35:55 +0200 Subject: [PATCH] Bug 36914: Remove DBIC warning in shelves.pl Content-Type: text/plain; charset=utf-8 Same fix as Bug 28561: Remove DBIC warning in opac-shelves But for staff Signed-off-by: Marcel de Rooy --- virtualshelves/shelves.pl | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/virtualshelves/shelves.pl b/virtualshelves/shelves.pl index ecf08fa9c7..593670d5ff 100755 --- a/virtualshelves/shelves.pl +++ b/virtualshelves/shelves.pl @@ -284,7 +284,8 @@ if ( $op eq 'view' ) { my $contents = $shelf->get_contents->search( {}, { - prefetch => [ { 'biblionumber' => { 'biblioitems' => 'items' } } ], + distinct => 'biblionumber', + join => [ { 'biblionumber' => { 'biblioitems' => 'items' } } ], page => $page, rows => $rows, order_by => { "-$direction" => $order_by }, -- 2.30.2