From 4d98f19541bef0e075c5c3d6b2709baa40d1aa60 Mon Sep 17 00:00:00 2001 From: David Roberts Date: Fri, 3 Apr 2020 15:23:01 +0000 Subject: [PATCH] Bug 24940: Serials statistics wizard: order vendor list alphabetically This patch changes the dropdown from being sorted by aqbookseller.id to aqbookseller.name To test: 1) Add at least 2 vendors: - First: ZZZZ - Second: AAAA 2) Add subscriptions for each of the vendors 3) Check the pull down in the serials statistics wizard and verify it lists them as ZZZZ, AAAA 4) Apply the patch 5) Re-check the pull down in the wizard and check that the vendors are now listed AAAA,ZZZZ Signed-off-by: Devinim Signed-off-by: Jonathan Druart Signed-off-by: Martin Renvoize Signed-off-by: Joy Nelson (cherry picked from commit ef8f3870b41032e1ae388baaeb8f13565a08dfaf) Signed-off-by: Lucas Gass --- reports/serials_stats.pl | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/reports/serials_stats.pl b/reports/serials_stats.pl index 0c5ed28331..dbdf61e866 100755 --- a/reports/serials_stats.pl +++ b/reports/serials_stats.pl @@ -138,7 +138,7 @@ if($do_it){ my $sth = $dbh->prepare("SELECT aqbooksellerid, aqbooksellers.name FROM subscription LEFT JOIN aqbooksellers ON (subscription.aqbooksellerid=aqbooksellers.id ) - GROUP BY aqbooksellerid"); + ORDER BY aqbooksellers.name ASC"); $sth->execute(); while(my $row = $sth->fetchrow_hashref){ -- 2.39.5