| Database Query | ||||||||
|---|---|---|---|---|---|---|---|---|
| ||||||||
select * from customfield where id=12617 |
| 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;
|