-- 已知自定义字段的ID和issue的ID，获取issue的自定义字段的值

-- 状态为“测试经理审核”（获取issue的ID）
select c.ID, c.SUMMARY,c.issuetype
from changeitem a 
LEFT JOIN changegroup b on a.groupid=b.id
LEFT JOIN jiraissue c ON b.issueid=c.ID
where a.NEWVALUE in ('10112') and b.CREATED>DATE_SUB(NOW(),INTERVAL 49 HOUR) 
and c.issuetype='10102'

-- 获取issueID对应的开发
select c.last_name 
from customfieldvalue a 
LEFT JOIN app_user  b on a.STRINGVALUE=b.user_key
LEFT JOIN cwd_user c on b.lower_user_name=c.user_name
where a.CUSTOMFIELD='10303' and a.ISSUE='12720'

-- 获取对应的工程名
select b.customvalue
from customfieldvalue a 
LEFT JOIN customfieldoption b on a.STRINGVALUE=b.ID
where a.CUSTOMFIELD='10203' and a.ISSUE='12720'