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 | ||||||||
---|---|---|---|---|---|---|---|---|
| ||||||||
mysql>select * desc customfieldvalue;from customfieldvalue where issue=(select id from jiraissue where pkey='SBA-30') |