Database Query | ||||||||
---|---|---|---|---|---|---|---|---|
| ||||||||
SELECT
issuenum, reporter, assignee, issuetype, summary, customfieldvalue.stringvalue
FROM
jiraissue
JOIN customfieldvalue ON jiraissue.id = customfieldvalue.issue where customfield=(select ID from customfield where cfname='Назва майданчика')
JOIN customfieldvalue ON jiraissue.id = customfieldvalue.issue where customfield=(select ID from customfield where cfname='Broker ID')
AND
project = (select id from project where pkey='SBM')
|
...