@@ -, +, @@ holds queue --- circ/pendingreserves.pl | 1 + misc/cronjobs/holds/build_holds_queue.pl | 5 ++++- 2 files changed, 5 insertions(+), 1 deletion(-) --- a/circ/pendingreserves.pl +++ a/circ/pendingreserves.pl @@ -142,6 +142,7 @@ if ( $run_report ) { AND items.itemnumber NOT IN (SELECT itemnumber FROM branchtransfers where datearrived IS NULL) AND issues.itemnumber IS NULL AND reserves.priority <> 0 + AND reserves.suspend = 0 AND notforloan = 0 AND damaged = 0 AND itemlost = 0 AND wthdrawn = 0 "; # GROUP BY reserves.biblionumber allows only items that are not checked out, else multiples occur when --- a/misc/cronjobs/holds/build_holds_queue.pl +++ a/misc/cronjobs/holds/build_holds_queue.pl @@ -82,7 +82,9 @@ sub GetBibsWithPendingHoldRequests { FROM reserves WHERE found IS NULL AND priority > 0 - AND reservedate <= CURRENT_DATE()"; + AND reservedate <= CURRENT_DATE() + AND suspend = 0 + "; my $sth = $dbh->prepare($bib_query); $sth->execute(); @@ -125,6 +127,7 @@ sub GetPendingHoldRequestsForBib { AND found IS NULL AND priority > 0 AND reservedate <= CURRENT_DATE() + AND suspend = 0 ORDER BY priority"; my $sth = $dbh->prepare($request_query); $sth->execute($biblionumber); --