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