Database Query | ||||||||
---|---|---|---|---|---|---|---|---|
| ||||||||
select * from customfieldvalueSELECT issuenum, reporter, assignee, issuetype, summary, customfieldvalue.stringvalue FROM jiraissue JOIN customfieldvalue ON jiraissue.id = customfieldvalue.issue where customfield=(select ID from customfield where cfname='Broker ID') | ||||||||
Database Query | ||||||||
| ||||||||
SELECT
*
FROM
jiraissue, issuestatus where issuestatus.id=jiraissue.issuestatus
AND
project = (select id from project where pkey='SBM')
|
...