From a3b12b0d8f1b633c39fae5dd0724f4cb20ac3988 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 Same fix as Bug 28561: Remove DBIC warning in opac-shelves But for staff --- virtualshelves/shelves.pl | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/virtualshelves/shelves.pl b/virtualshelves/shelves.pl index 90b5c93fa94..badd78f9953 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.34.1