From 2bea7b0d14baf48e30b893e5869ae9ff09eec5de Mon Sep 17 00:00:00 2001 From: Martin Renvoize Date: Thu, 2 May 2024 12:53:56 +0100 Subject: [PATCH] Bug 30581: Allow requested but not sent items to appear in holds to pull This patch adds datesent to the exclusions in holds to pull report. --- circ/pendingreserves.pl | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/circ/pendingreserves.pl b/circ/pendingreserves.pl index 11182e12b12..ef2400be05a 100755 --- a/circ/pendingreserves.pl +++ b/circ/pendingreserves.pl @@ -153,7 +153,7 @@ my %where = ( 'itembib.itemlost' => 0, 'itembib.withdrawn' => 0, 'itembib.notforloan' => 0, - 'itembib.itemnumber' => { -not_in => \'SELECT itemnumber FROM branchtransfers WHERE datearrived IS NULL AND datecancelled IS NULL' } + 'itembib.itemnumber' => { -not_in => \'SELECT itemnumber FROM branchtransfers WHERE datearrived IS NULL AND datecancelled IS NULL AND datesent IS NULL' } ); # date boundaries -- 2.44.0