Mercurial > hg > LightPIT / file diff

--- a/src/main/java/de/uapcore/lightpit/dao/postgres/PGIssueDao.java	Sat Aug 29 16:48:15 2020 +0200
+++ b/src/main/java/de/uapcore/lightpit/dao/postgres/PGIssueDao.java	Sat Aug 29 17:13:09 2020 +0200
@@ -54,7 +54,7 @@
                         "userid, username, givenname, lastname, mail, " +
                         "created, updated, eta " +
                         "from lpit_issue i " +
-                        "left join lpit_project p on project = projectid " +
+                        "join lpit_project p on project = projectid " +
                         "left join lpit_user on userid = assignee " +
                         "where project = ? "+
                         "order by eta asc, updated desc");
@@ -67,10 +67,10 @@
                         "userid, username, givenname, lastname, mail, " +
                         "created, updated, eta " +
                         "from lpit_issue i " +
-                        "join issue_version using (issueid) "+
-                        "left join lpit_project p on project = projectid " +
+                        "join lpit_project p on project = projectid " +
+                        "left join issue_version using (issueid) "+
                         "left join lpit_user on userid = assignee " +
-                        "where versionid = ? "+
+                        "where coalesce(versionid,-1) = ? "+
                         "order by eta asc, updated desc"
         );
 
@@ -222,7 +222,7 @@
 
     @Override
     public List<Issue> list(Version version) throws SQLException {
-        return list(listForVersion, version.getId());
+        return list(listForVersion, version == null ? -1 : version.getId());
     }
 
     @Override