禅道自带的统计只能按照项目统计,可是研发中心的助理要求统计出每个人在所有项目中的bug数量,经过摸索,得出以下sql,供大家参考:
select pd.name as 产品,pj.name as 项目,b.id as bug_id,b.title as bug标题, la2.value as 类型,b.`status`,u1.realname as 提交人,u2.realname as 解决人,la.value as 解决方案,b.openedDate as 创建时间 ,b.resolvedDate as 解决时间
from zt_bug b INNER JOIN zt_product pd on b.product = pd.id
left JOIN zt_project pj on pj.id = b.project
join zt_user u1 on u1.account = b.openedBy
join zt_user u2 on u2.account = b.resolvedBy
join zt_lang la on b.resolution = la.key and la.section = 'resolutionList'
join zt_lang la2 on b.type = la2.key and la2.lang = 'zh-cn'
where b.openedDate > '2020-05-01 00:00:00' and b.confirmed = '1'
order by b.openedDate desc
转载请注明出处,谢谢各位大佬!