Sat, 31 Oct 2020 09:27:36 +0100
wrong sort order for components - fixes #35
src/main/java/de/uapcore/lightpit/dao/postgres/PGComponentDao.java | file | annotate | diff | comparison | revisions |
1.1 --- a/src/main/java/de/uapcore/lightpit/dao/postgres/PGComponentDao.java Sat Oct 31 09:15:57 2020 +0100 1.2 +++ b/src/main/java/de/uapcore/lightpit/dao/postgres/PGComponentDao.java Sat Oct 31 09:27:36 2020 +0100 1.3 @@ -51,8 +51,7 @@ 1.4 "from lpit_component " + 1.5 "left join lpit_user on lead = userid"; 1.6 1.7 - list = connection.prepareStatement(query + " where project = ? " + 1.8 - "order by ordinal desc, lower(name) desc"); 1.9 + list = connection.prepareStatement(query + " where project = ? order by ordinal, lower(name)"); 1.10 1.11 find = connection.prepareStatement(query + " where id = ? "); 1.12