禅道统计整个系统中所有人已解决的bug-sql

禅道自带的统计只能按照项目统计，可是研发中心的助理要求统计出每个人在所有项目中的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

转载请注明出处，谢谢各位大佬！