From 8acb17fb8b1fca6e47de0a94dcb09c84d7d6131f Mon Sep 17 00:00:00 2001 From: Andrew Fuerste-Henry Date: Fri, 9 Oct 2020 13:56:56 +0000 Subject: [PATCH] Bug 26646: Group holds to pull by item rather than bib To test: 1 - find a bib with 2 items 2 - place an item-level hold on item 1 for patron A 3 - place an item-level hold on item 2 for patron B 4 - go to Holds to Pull 5 - it shows one entry for the bib, indicates 2 items should be pulled, but only lists patron A 6 - apply patch, restart services 7 - reload Holds to Pull, confirm it now shows two entries, one for each item --- circ/pendingreserves.pl | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/circ/pendingreserves.pl b/circ/pendingreserves.pl index dd6ae7699d..8bcfa6f77e 100755 --- a/circ/pendingreserves.pl +++ b/circ/pendingreserves.pl @@ -243,7 +243,7 @@ if (C4::Context->preference('IndependentBranches')){ $strsth .= " AND items.holdingbranch=? "; push @query_params, C4::Context->userenv->{'branch'}; } -$strsth .= " GROUP BY reserves.biblionumber ORDER BY biblio.title "; +$strsth .= " GROUP BY reserves.itemnumber,reserves.biblionumber ORDER BY biblio.title "; my $sth = $dbh->prepare($strsth); $sth->execute(@query_params); -- 2.11.0