# HG changeset patch
# User Mike Becker <universe@uap-core.de>
# Date 1604132856 -3600
# Node ID e914fbf4decc02597be44eac30bbd8459f0288bd
# Parent  7761c37c5e611eb961d7678bbdb0e25d27baf6b5
wrong sort order for components - fixes #35

diff -r 7761c37c5e61 -r e914fbf4decc src/main/java/de/uapcore/lightpit/dao/postgres/PGComponentDao.java
--- a/src/main/java/de/uapcore/lightpit/dao/postgres/PGComponentDao.java	Sat Oct 31 09:15:57 2020 +0100
+++ b/src/main/java/de/uapcore/lightpit/dao/postgres/PGComponentDao.java	Sat Oct 31 09:27:36 2020 +0100
@@ -51,8 +51,7 @@
                 "from lpit_component " +
                 "left join lpit_user on lead = userid";
 
-        list = connection.prepareStatement(query + " where project = ? " +
-                        "order by ordinal desc, lower(name) desc");
+        list = connection.prepareStatement(query + " where project = ? order by ordinal, lower(name)");
 
         find = connection.prepareStatement(query + " where id = ? ");