comparison: src/main/java/de/uapcore/lightpit/dao/postgres/PGIssueDao.java
src/main/java/de/uapcore/lightpit/dao/postgres/PGIssueDao.java
- changeset 121
- 428dca747d6b
- parent 105
- 250c5cbb8276
- child 124
- ed2e7aef2a3e
equal
deleted
inserted
replaced
| 120:5d4c12338fe0 | 121:428dca747d6b |
|---|---|
| 54 "userid, username, givenname, lastname, mail, " + | 54 "userid, username, givenname, lastname, mail, " + |
| 55 "created, updated, eta " + | 55 "created, updated, eta " + |
| 56 "from lpit_issue i " + | 56 "from lpit_issue i " + |
| 57 "join lpit_project p on project = projectid " + | 57 "join lpit_project p on project = projectid " + |
| 58 "left join lpit_user on userid = assignee " + | 58 "left join lpit_user on userid = assignee " + |
| 59 "where project = ? "+ | 59 "where project = ? "); |
| 60 "order by eta asc, updated desc"); | |
| 61 | 60 |
| 62 listForVersion = connection.prepareStatement( | 61 listForVersion = connection.prepareStatement( |
| 63 "with issue_version as ( "+ | 62 "with issue_version as ( "+ |
| 64 "select issueid, versionid from lpit_issue_affected_version union "+ | 63 "select issueid, versionid from lpit_issue_affected_version union "+ |
| 65 "select issueid, versionid from lpit_issue_resolved_version) "+ | 64 "select issueid, versionid from lpit_issue_resolved_version) "+ |
| 68 "created, updated, eta " + | 67 "created, updated, eta " + |
| 69 "from lpit_issue i " + | 68 "from lpit_issue i " + |
| 70 "join lpit_project p on project = projectid " + | 69 "join lpit_project p on project = projectid " + |
| 71 "left join issue_version using (issueid) "+ | 70 "left join issue_version using (issueid) "+ |
| 72 "left join lpit_user on userid = assignee " + | 71 "left join lpit_user on userid = assignee " + |
| 73 "where coalesce(versionid,-1) = ? "+ | 72 "where coalesce(versionid,-1) = ? " |
| 74 "order by eta asc, updated desc" | |
| 75 ); | 73 ); |
| 76 | 74 |
| 77 find = connection.prepareStatement( | 75 find = connection.prepareStatement( |
| 78 "select issueid, project, p.name as projectname, status, category, subject, i.description, " + | 76 "select issueid, project, p.name as projectname, status, category, subject, i.description, " + |
| 79 "userid, username, givenname, lastname, mail, " + | 77 "userid, username, givenname, lastname, mail, " + |
