From b5ca683b3a740ba196ae704061c5c9988ac2c045 Mon Sep 17 00:00:00 2001 From: INOPIAE Date: Tue, 8 Jan 2019 06:03:59 +0100 Subject: [PATCH 1/1] upd: change sorting of trainings to descending Enable user to find the last records easier, especially for support. Change-Id: I3a1aacbf8d4c128b99640e443df1a97606786005 --- src/club/wpia/gigi/dbObjects/User.java | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/src/club/wpia/gigi/dbObjects/User.java b/src/club/wpia/gigi/dbObjects/User.java index 1c6b39b3..10586d71 100644 --- a/src/club/wpia/gigi/dbObjects/User.java +++ b/src/club/wpia/gigi/dbObjects/User.java @@ -572,7 +572,7 @@ public class User extends CertificateOwner { } public String[] getTrainings() { - try (GigiPreparedStatement prep = new GigiPreparedStatement("SELECT `pass_date`, `type_text`, `language`, `version` FROM `cats_passed` LEFT JOIN `cats_type` ON `cats_type`.`id`=`cats_passed`.`variant_id` WHERE `user_id`=? ORDER BY `pass_date` ASC")) { + try (GigiPreparedStatement prep = new GigiPreparedStatement("SELECT `pass_date`, `type_text`, `language`, `version` FROM `cats_passed` LEFT JOIN `cats_type` ON `cats_type`.`id`=`cats_passed`.`variant_id` WHERE `user_id`=? ORDER BY `pass_date` DESC")) { prep.setInt(1, getId()); GigiResultSet res = prep.executeQuery(); List entries = new LinkedList(); -- 2.39.2