From 3463dd244928e50e2a5e8b90f06dd072d7a93241 Mon Sep 17 00:00:00 2001 From: Kyle M Hall Date: Mon, 24 Feb 2014 11:32:39 -0500 Subject: [PATCH] Bug 11126 [QA Followup] - Make reserves returned by _Findgroupreserve sorted by priority Signed-off-by: Jonathan Druart Signed-off-by: Tomas Cohen Arazi --- C4/Reserves.pm | 3 +++ 1 file changed, 3 insertions(+) diff --git a/C4/Reserves.pm b/C4/Reserves.pm index bb707131e7..c4fe7c0fbb 100644 --- a/C4/Reserves.pm +++ b/C4/Reserves.pm @@ -1890,6 +1890,7 @@ sub _Findgroupreserve { AND itemnumber = ? AND reservedate <= DATE_ADD(NOW(),INTERVAL ? DAY) AND suspend = 0 + ORDER BY priority /; my $sth = $dbh->prepare($item_level_target_query); $sth->execute($itemnumber, $lookahead||0); @@ -1922,6 +1923,7 @@ sub _Findgroupreserve { AND hold_fill_targets.itemnumber = ? AND reservedate <= DATE_ADD(NOW(),INTERVAL ? DAY) AND suspend = 0 + ORDER BY priority /; $sth = $dbh->prepare($title_level_target_query); $sth->execute($itemnumber, $lookahead||0); @@ -1955,6 +1957,7 @@ sub _Findgroupreserve { AND (reserves.itemnumber IS NULL OR reserves.itemnumber = ?) AND reserves.reservedate <= DATE_ADD(NOW(),INTERVAL ? DAY) AND suspend = 0 + ORDER BY priority /; $sth = $dbh->prepare($query); $sth->execute( $biblio, $bibitem, $itemnumber, $lookahead||0); -- 2.20.1