diff -r e914fbf4decc -r 3d10f2a390a1 src/main/java/de/uapcore/lightpit/dao/postgres/PGIssueDao.java --- a/src/main/java/de/uapcore/lightpit/dao/postgres/PGIssueDao.java Sat Oct 31 09:27:36 2020 +0100 +++ b/src/main/java/de/uapcore/lightpit/dao/postgres/PGIssueDao.java Sat Oct 31 09:50:15 2020 +0100 @@ -67,7 +67,8 @@ "select issueid, versionid from lpit_issue_resolved_version) "+ query + "left join issue_version using (issueid) "+ - "where coalesce(versionid,-1) = ? and coalesce(component, -1) = coalesce(?, component, -1)" + "where i.project = ? "+ + "and coalesce(versionid,-1) = ? and coalesce(component, -1) = coalesce(?, component, -1)" ); find = connection.prepareStatement(query + "where issueid = ? "); @@ -220,15 +221,17 @@ @Override public List list(Project project, Component component, Version version) throws SQLException { - listForVersion.setInt(1, Optional.ofNullable(version).map(Version::getId).orElse(-1)); - listForVersion.setInt(2, Optional.ofNullable(component).map(Component::getId).orElse(-1)); + listForVersion.setInt(1, project.getId()); + listForVersion.setInt(2, Optional.ofNullable(version).map(Version::getId).orElse(-1)); + listForVersion.setInt(3, Optional.ofNullable(component).map(Component::getId).orElse(-1)); return executeQuery(listForVersion); } @Override public List list(Project project, Version version) throws SQLException { - listForVersion.setInt(1, Optional.ofNullable(version).map(Version::getId).orElse(-1)); - listForVersion.setNull(2, Types.INTEGER); + listForVersion.setInt(1, project.getId()); + listForVersion.setInt(2, Optional.ofNullable(version).map(Version::getId).orElse(-1)); + listForVersion.setNull(3, Types.INTEGER); return executeQuery(listForVersion); }