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