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
     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  

mercurial