From 3323668f945ecb427e6cfd5d60e760885f94101e Mon Sep 17 00:00:00 2001 From: Sophie Meynieux Date: Wed, 26 Dec 2012 17:36:45 +0100 Subject: [PATCH] BZ 9320 : Pending reserves report (circ/pendingreserves.pl) should not show items on hold waiting to be picked up Test plan : * chose an item reserved by multiple patrons. * return the item and confirm reservation => item is waiting to be picked up * run circ/pendingreserves.pl => without patch, this item is shown in the list => with the patch, only really available items are show. Signed-off-by: Chris Cormack --- circ/pendingreserves.pl | 1 + 1 file changed, 1 insertion(+) diff --git a/circ/pendingreserves.pl b/circ/pendingreserves.pl index e532faf..0893396 100755 --- a/circ/pendingreserves.pl +++ b/circ/pendingreserves.pl @@ -141,6 +141,7 @@ if ( $run_report ) { $sqldatewhere AND (reserves.itemnumber IS NULL OR reserves.itemnumber = items.itemnumber) AND items.itemnumber NOT IN (SELECT itemnumber FROM branchtransfers where datearrived IS NULL) + AND items.itemnumber NOT IN (select itemnumber FROM reserves where found='W') AND issues.itemnumber IS NULL AND reserves.priority <> 0 AND reserves.suspend = 0 -- 1.7.10.4