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'in (12602,12617) AND project = (select id from project where pkey='SBM') |
...