From a0b885c98ccad474e5d2de275f694a72d41ff643 Mon Sep 17 00:00:00 2001 From: Sophie Meynieux Date: Wed, 26 Dec 2012 17:36:45 +0100 Subject: [PATCH] Bug 9320 Pending reserves report should not show waiting items 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: Owen Leonard Works according to test plan. The title with one waiting item appeared in pending holds report before the patch, doesn't appear after the patch. Signed-off-by: Jonathan Druart Signed-off-by: Jared Camins-Esakov --- circ/pendingreserves.pl | 1 + 1 file changed, 1 insertion(+) diff --git a/circ/pendingreserves.pl b/circ/pendingreserves.pl index 0f5d3da78a..31ecd85612 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 -- 2.39.5