| 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 where issuestatus.id=jiraissue.issuestatus LEFT JOIN customfieldvalue ON jiraissue.id = customfield
AND
project = (select id from project where pkey='SBM')
|