From 88722fe9fd9b02b717572fc8590fd306182a2a6a 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 426eab9..fce34c1 100644 --- a/C4/Reserves.pm +++ b/C4/Reserves.pm @@ -1831,6 +1831,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); @@ -1863,6 +1864,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); @@ -1896,6 +1898,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