comparison: src/main/kotlin/de/uapcore/lightpit/dao/PostgresDataAccessObject.kt
src/main/kotlin/de/uapcore/lightpit/dao/PostgresDataAccessObject.kt
- changeset 183
- 61669abf277f
- parent 180
- 009700915269
- child 184
- e8eecee6aadf
equal
deleted
inserted
replaced
| 182:53f0e2685ad5 | 183:61669abf277f |
|---|---|
| 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 |
