From a1b285bb8c2563d68eaa6851a00e67636c03b83e Mon Sep 17 00:00:00 2001 From: Paul Poulain Date: Tue, 5 Apr 2011 14:43:23 +0200 Subject: [PATCH] Bug 6062: ordering basketgroups When you have many basketgroups, you get the oldest one on top. Usually, you have something to do on recent ones, so it's better to have basket groups ordered DESC Signed-off-by: Katrin Fischer Signed-off-by: Chris Cormack (cherry picked from commit 311e81810ab894b2b7f2dc186cbf3a8c6a337a1f) Signed-off-by: Chris Nighswonger --- C4/Acquisition.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/C4/Acquisition.pm b/C4/Acquisition.pm index d262b09a77..0f7632bbc0 100644 --- a/C4/Acquisition.pm +++ b/C4/Acquisition.pm @@ -658,7 +658,7 @@ Returns a reference to the array of all the basketgroups of bookseller $booksell sub GetBasketgroups { my $booksellerid = shift; die "bookseller id is required to edit a basketgroup" unless $booksellerid; - my $query = "SELECT * FROM aqbasketgroups WHERE booksellerid=?"; + my $query = "SELECT * FROM aqbasketgroups WHERE booksellerid=? ORDER BY `id` DESC"; my $dbh = C4::Context->dbh; my $sth = $dbh->prepare($query); $sth->execute($booksellerid); -- 2.39.5