src/main/java/de/uapcore/lightpit/dao/postgres/PGComponentDao.java

changeset 153
e914fbf4decc
parent 138
e2aa673dd473
--- 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 = ? ");
 

mercurial