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