SELECT DISTINCT issuenum as ТІКЕТ, summary as ТЕМА,
CASE customvalue
WHEN 'ДЗК (ЦБД-2)' THEN issuestatus.pname
ELSE '---'
END AS ДЗК_ЦБД2,
CASE customvalue
WHEN 'Загальна процедура (ЦБД-2)' THEN issuestatus.pname
ELSE '---'
END AS Загальна_процедура_ЦБД2,
CASE customvalue
WHEN 'Мала приватизація (ЦБД-2)' THEN issuestatus.pname
ELSE '---'
END AS Мала_приватизація_ЦБД2,
CASE customvalue
WHEN 'Оренда майна (ЦБД-2)' THEN issuestatus.pname
ELSE '---'
END AS Оренда_майна_ЦБД_2,
CASE customvalue
WHEN 'УкрОборонПром (ЦБД-2)' THEN issuestatus.pname
ELSE '---'
END AS УкрОборонПром_ЦБД2,
CASE customvalue
WHEN 'ФГВ (ЦБД-1)' THEN issuestatus.pname
ELSE '---'
END AS ФГВ_ЦБД1
FROM customfieldvalue
JOIN jiraissue ON jiraissue.id = customfieldvalue.issue
JOIN issuestatus ON issuestatus.id = jiraissue.issuestatus
JOIN customfieldoption ON customfieldvalue.customfield = customfieldoption.customfield
AND customfieldoption.id = cast(customfieldvalue.STRINGVALUE as decimal)
WHERE customfieldvalue.customfield in (12601)
|