From b934b06dd91e04e5f581d4c697584cd35d897a51 Mon Sep 17 00:00:00 2001 From: Pedro Amorim Date: Mon, 22 Jan 2024 10:48:53 +0000 Subject: [PATCH] Bug 32565: WIP - Minor fixes to have WIP working --- C4/HoldsQueue.pm | 2 +- misc/cronjobs/holds/build_holds_queue.pl | 1 + 2 files changed, 2 insertions(+), 1 deletion(-) diff --git a/C4/HoldsQueue.pm b/C4/HoldsQueue.pm index 2ee9fdf478..40de1dcad6 100644 --- a/C4/HoldsQueue.pm +++ b/C4/HoldsQueue.pm @@ -277,7 +277,7 @@ sub GetPendingHoldRequestsForBib { AND priority > 0 AND reservedate <= CURRENT_DATE() AND suspend = 0 "; - $request_query .= "AND reserve_id NOT IN (SELECT reserve_id FROM tmp_holdsqueue " if $unallocated; + $request_query .= "AND reserve_id NOT IN (SELECT reserve_id FROM tmp_holdsqueue) " if $unallocated; $request_query .= "ORDER BY priority"; my $sth = $dbh->prepare($request_query); $sth->execute($biblionumber); diff --git a/misc/cronjobs/holds/build_holds_queue.pl b/misc/cronjobs/holds/build_holds_queue.pl index 4c16eac189..06b02041e5 100755 --- a/misc/cronjobs/holds/build_holds_queue.pl +++ b/misc/cronjobs/holds/build_holds_queue.pl @@ -62,6 +62,7 @@ This script builds or rebuilds the entire holds queue. my $help = 0; my $man = 0; my $force = 0; +my $unallocated = 0; my $command_line_options = join( " ", @ARGV ); -- 2.30.2