54 "userid, username, givenname, lastname, mail, " + |
54 "userid, username, givenname, lastname, mail, " + |
55 "created, updated, eta " + |
55 "created, updated, eta " + |
56 "from lpit_issue i " + |
56 "from lpit_issue i " + |
57 "join lpit_project p on project = projectid " + |
57 "join lpit_project p on project = projectid " + |
58 "left join lpit_user on userid = assignee " + |
58 "left join lpit_user on userid = assignee " + |
59 "where project = ? "+ |
59 "where project = ? "); |
60 "order by eta asc, updated desc"); |
|
61 |
60 |
62 listForVersion = connection.prepareStatement( |
61 listForVersion = connection.prepareStatement( |
63 "with issue_version as ( "+ |
62 "with issue_version as ( "+ |
64 "select issueid, versionid from lpit_issue_affected_version union "+ |
63 "select issueid, versionid from lpit_issue_affected_version union "+ |
65 "select issueid, versionid from lpit_issue_resolved_version) "+ |
64 "select issueid, versionid from lpit_issue_resolved_version) "+ |
68 "created, updated, eta " + |
67 "created, updated, eta " + |
69 "from lpit_issue i " + |
68 "from lpit_issue i " + |
70 "join lpit_project p on project = projectid " + |
69 "join lpit_project p on project = projectid " + |
71 "left join issue_version using (issueid) "+ |
70 "left join issue_version using (issueid) "+ |
72 "left join lpit_user on userid = assignee " + |
71 "left join lpit_user on userid = assignee " + |
73 "where coalesce(versionid,-1) = ? "+ |
72 "where coalesce(versionid,-1) = ? " |
74 "order by eta asc, updated desc" |
|
75 ); |
73 ); |
76 |
74 |
77 find = connection.prepareStatement( |
75 find = connection.prepareStatement( |
78 "select issueid, project, p.name as projectname, status, category, subject, i.description, " + |
76 "select issueid, project, p.name as projectname, status, category, subject, i.description, " + |
79 "userid, username, givenname, lastname, mail, " + |
77 "userid, username, givenname, lastname, mail, " + |