wrong sort order for components - fixes #35

Sat, 31 Oct 2020 09:27:36 +0100

author
Mike Becker <universe@uap-core.de>
date
Sat, 31 Oct 2020 09:27:36 +0100
changeset 153
e914fbf4decc
parent 152
7761c37c5e61
child 154
3d10f2a390a1

wrong sort order for components - fixes #35

src/main/java/de/uapcore/lightpit/dao/postgres/PGComponentDao.java file | annotate | diff | comparison | revisions
--- 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