Database Query | ||||||||
---|---|---|---|---|---|---|---|---|
| ||||||||
select * from customfieldvalue where customfield=(select ID from customfield where cfname='Broker ID') |
Database Query | ||||||||
---|---|---|---|---|---|---|---|---|
| ||||||||
SELECT
issuenum, issuestatus.pname, reporter, assignee, issuetype, summary
FROM
jiraissue, issuestatus
AND
issuestatus.id = jiraissue.issuestatus
ORDER BY issuenum;
|