...
Database Query | ||||||||
---|---|---|---|---|---|---|---|---|
| ||||||||
SELECT issuenum, issuestatus.pname, reporter, assignee, issuetype, summary FROM jiraissue, issuestatus where issuestatus.id=jiraissue.issuestatus LEFT JOIN customfieldvalue ON jiraissue.id = customfield AND project = (select id from project where pkey='SBM') ORDER BY issuenum; |