Mercurial > hg > LightPIT / changeset

--- a/src/main/kotlin/de/uapcore/lightpit/dao/PostgresDataAccessObject.kt	Wed Jan 06 16:41:09 2021 +0100
+++ b/src/main/kotlin/de/uapcore/lightpit/dao/PostgresDataAccessObject.kt	Sat Jan 23 14:47:59 2021 +0100
@@ -547,11 +547,16 @@
             with issue_version as (
                 select issueid, versionid from lpit_issue_affected_version
                 union select issueid, versionid from lpit_issue_resolved_version
-            ) ${issueQuery} left join issue_version using (issueid)
-            where
-            (not ? or projectid = ?) and 
-            (not ? or versionid = ?) and (not ? or versionid is null) and
-            (not ? or component = ?) and (not ? or component is null)
+            ),
+            filteterd_issues as (
+                select distinct issueid from lpit_issue
+                left join issue_version using (issueid)
+                where
+                (not ? or project = ?) and 
+                (not ? or versionid = ?) and (not ? or versionid is null) and
+                (not ? or component = ?) and (not ? or component is null)
+            )
+            ${issueQuery} join filteterd_issues using (issueid)
             """
         )
     }