Database Query | ||||||||
---|---|---|---|---|---|---|---|---|
| ||||||||
SELECT
issuenum as ТІКЕТ
, summary as ТЕМА
, customfieldvalue.stringvalue as ОРГАНІЗАЦІЯ
, CONCAT('*', 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')
|
Database Query | ||||||||
---|---|---|---|---|---|---|---|---|
| ||||||||
SELECT
customfield
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')
|