545 connection.prepareStatement( |
545 connection.prepareStatement( |
546 """ |
546 """ |
547 with issue_version as ( |
547 with issue_version as ( |
548 select issueid, versionid from lpit_issue_affected_version |
548 select issueid, versionid from lpit_issue_affected_version |
549 union select issueid, versionid from lpit_issue_resolved_version |
549 union select issueid, versionid from lpit_issue_resolved_version |
550 ) ${issueQuery} left join issue_version using (issueid) |
550 ), |
551 where |
551 filteterd_issues as ( |
552 (not ? or projectid = ?) and |
552 select distinct issueid from lpit_issue |
553 (not ? or versionid = ?) and (not ? or versionid is null) and |
553 left join issue_version using (issueid) |
554 (not ? or component = ?) and (not ? or component is null) |
554 where |
|
555 (not ? or project = ?) and |
|
556 (not ? or versionid = ?) and (not ? or versionid is null) and |
|
557 (not ? or component = ?) and (not ? or component is null) |
|
558 ) |
|
559 ${issueQuery} join filteterd_issues using (issueid) |
555 """ |
560 """ |
556 ) |
561 ) |
557 } |
562 } |
558 |
563 |
559 private val fproj = 1 |
564 private val fproj = 1 |