From 7954504c6c1a6fe4619e05467405606267b46cea Mon Sep 17 00:00:00 2001 From: Paul Poulain Date: Tue, 5 Apr 2011 14:27:35 +0200 Subject: [PATCH] [SIGNED-OFF] BZ6062: ordering basketgroups Content-Type: text/plain; charset="utf-8" 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 --- C4/Acquisition.pm | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diff --git a/C4/Acquisition.pm b/C4/Acquisition.pm index 7474502..2aa4cf2 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); -- 1.7.1