comparison: src/main/java/de/uapcore/lightpit/dao/postgres/PGComponentDao.java
src/main/java/de/uapcore/lightpit/dao/postgres/PGComponentDao.java
- changeset 153
- e914fbf4decc
- parent 138
- e2aa673dd473
equal
deleted
inserted
replaced
| 152:7761c37c5e61 | 153:e914fbf4decc |
|---|---|
| 49 final var query = "select id, name, node, color, ordinal, description, " + | 49 final var query = "select id, name, node, color, ordinal, description, " + |
| 50 "userid, username, givenname, lastname, mail " + | 50 "userid, username, givenname, lastname, mail " + |
| 51 "from lpit_component " + | 51 "from lpit_component " + |
| 52 "left join lpit_user on lead = userid"; | 52 "left join lpit_user on lead = userid"; |
| 53 | 53 |
| 54 list = connection.prepareStatement(query + " where project = ? " + | 54 list = connection.prepareStatement(query + " where project = ? order by ordinal, lower(name)"); |
| 55 "order by ordinal desc, lower(name) desc"); | |
| 56 | 55 |
| 57 find = connection.prepareStatement(query + " where id = ? "); | 56 find = connection.prepareStatement(query + " where id = ? "); |
| 58 | 57 |
| 59 findByNode = connection.prepareStatement(query + " where project = ? and node = ?"); | 58 findByNode = connection.prepareStatement(query + " where project = ? and node = ?"); |
| 60 | 59 |
