Database Query | ||||||||
---|---|---|---|---|---|---|---|---|
| ||||||||
SELECT issuenum, issuestatus.pname, reporter, assignee, issuetype, summary FROM jiraissue, issuestatus WHERE project = (select id from project where pkey='SBM') AND issuestatus.id = jiraissue.issuestatus ORDER BY issuenum; |
Database Query | ||||||||
---|---|---|---|---|---|---|---|---|
| ||||||||
SELECT p.id AS project_id, p.pname AS project_name, p.lead AS project_lead, ji.pkey AS issue_id, ji.reporter AS issue_reporter, pri.pname AS issue_priority, ist.pname AS issue_status, ji.summary AS issue_summary FROM project p LEFT OUTER JOIN jiraissue ji ON ji.project = p.id LEFT OUTER JOIN priority pri ON ji.priority = pri.id LEFT OUTER JOIN issuestatus ist ON ji.issuestatus = ist.id WHERE p.pname = '<SBM>' ORDER BY ji.pkeyissuenum; |