Database Query | ||||||||
---|---|---|---|---|---|---|---|---|
| ||||||||
SELECT
issuenum as ТІКЕТ
, summary as ТЕМА
, customfieldvalue.stringvalue as ОРГАНІЗАЦІЯ
, issuestatus.pname as СТАТУС
FROM jiraissue
JOIN issuestatus ON issuestatus.id=jiraissue.issuestatus
JOIN customfieldvalue ON jiraissue.id = customfieldvalue.issue
where customfield in (12602,12617)
AND project = (select id from project where pkey='SBM')
|