1.1 --- a/src/main/java/de/uapcore/lightpit/dao/postgres/PGIssueDao.java Sat Aug 29 16:48:15 2020 +0200
1.2 +++ b/src/main/java/de/uapcore/lightpit/dao/postgres/PGIssueDao.java Sat Aug 29 17:13:09 2020 +0200
1.3 @@ -54,7 +54,7 @@
1.4 "userid, username, givenname, lastname, mail, " +
1.5 "created, updated, eta " +
1.6 "from lpit_issue i " +
1.7 - "left join lpit_project p on project = projectid " +
1.8 + "join lpit_project p on project = projectid " +
1.9 "left join lpit_user on userid = assignee " +
1.10 "where project = ? "+
1.11 "order by eta asc, updated desc");
1.12 @@ -67,10 +67,10 @@
1.13 "userid, username, givenname, lastname, mail, " +
1.14 "created, updated, eta " +
1.15 "from lpit_issue i " +
1.16 - "join issue_version using (issueid) "+
1.17 - "left join lpit_project p on project = projectid " +
1.18 + "join lpit_project p on project = projectid " +
1.19 + "left join issue_version using (issueid) "+
1.20 "left join lpit_user on userid = assignee " +
1.21 - "where versionid = ? "+
1.22 + "where coalesce(versionid,-1) = ? "+
1.23 "order by eta asc, updated desc"
1.24 );
1.25
1.26 @@ -222,7 +222,7 @@
1.27
1.28 @Override
1.29 public List<Issue> list(Version version) throws SQLException {
1.30 - return list(listForVersion, version.getId());
1.31 + return list(listForVersion, version == null ? -1 : version.getId());
1.32 }
1.33
1.34 @Override
