From 22e460d51e2d4bcb654d82a8d3e6a8f50142275d 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 --- C4/Reserves.pm | 3 +++ 1 files changed, 3 insertions(+), 0 deletions(-) diff --git a/C4/Reserves.pm b/C4/Reserves.pm index 843ec3a..fc3dade 100644 --- a/C4/Reserves.pm +++ b/C4/Reserves.pm @@ -1819,6 +1819,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); @@ -1850,6 +1851,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); @@ -1882,6 +1884,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); -- 1.7.2.5