From 4e3bb42ba2d8777fe01e57191f6fd9f170921c70 Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Mon, 18 May 2020 12:59:47 +0200 Subject: [PATCH] Bug 24301: Retrieve patron's info for hold with priority = 1 And not the first one in the table. Can we always assume there is a priority=1? Test plan: Check an item out Place some item level hold on the item Change the some priotities of the hold Go to the holds to pull list Note that the patron who is the next in the list (piority=1) is listed Signed-off-by: Michal Denar Signed-off-by: Josef Moravec --- circ/pendingreserves.pl | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/circ/pendingreserves.pl b/circ/pendingreserves.pl index 7f2062942a..f59b95900c 100755 --- a/circ/pendingreserves.pl +++ b/circ/pendingreserves.pl @@ -225,7 +225,7 @@ my $strsth = AND items.itemnumber NOT IN (SELECT itemnumber FROM branchtransfers where datearrived IS NULL) AND items.itemnumber NOT IN (select itemnumber FROM reserves where found IS NOT NULL) AND issues.itemnumber IS NULL - AND reserves.priority <> 0 + AND reserves.priority = 1 AND reserves.suspend = 0 AND notforloan = 0 AND itemlost = 0 AND withdrawn = 0 AND ( circulation_rules.rule_value IS NULL OR circulation_rules.rule_value != 0 ) -- 2.11.0