本文共 1724 字，大约阅读时间需要 5 分钟。

???Jira????????????????

?????????????????????????Jira??????????????????????????????????????

???????? ????????????????????????????????????????????????????????????????????????SQL???????

????????bug???? SELECT COUNT(*) num, openedBy, realname FROM zt_bug b INNER JOIN zt_user u ON u.account = b.openedBy WHERE DATE_FORMAT(b.openedDate, '%Y%m') = '202003' AND b.resolution NOT IN ('bydesign', 'duplicate', 'external', 'notrepro', 'willnotfix') GROUP BY openedBy ORDER BY num DESC;

??????bug???? SELECT COUNT(*) num, openedBy, realname FROM zt_bug b INNER JOIN zt_user u ON u.account = b.resolvedBy WHERE DATE_FORMAT(b.openedDate, '%Y%m') = '202304' GROUP BY resolvedBy ORDER BY num DESC;

??Bug?????????????? SELECT SUM(num) num, realname FROM ( SELECT b.id, COUNT(1) num, u.realname realname FROM zt_bug b INNER JOIN zt_action a ON a.objectID = b.id INNER JOIN zt_user u ON u.account = b.resolvedBy WHERE DATE_FORMAT(b.openedDate, '%Y%m') = '201204' AND a.objectType = 'bug' AND a.action = 'activated' GROUP BY b.id ORDER BY num DESC ) tem GROUP BY tem.realname ORDER BY num DESC;

Jira?????? Jira??????????????????????????????????Jira??????????

????????????????????? SELECT p.pname, u.lower_user_name username, SUM(l.timeworked / 28800) all_time FROM jiraissue ji INNER JOIN project p ON ji.PROJECT = p.ID INNER JOIN worklog l ON ji.id = l.issueid INNER JOIN app_user u ON l.UPDATEAUTHOR = u.user_key WHERE l.startdate BETWEEN '2020-03-01' AND '2020-03-31 23:59:59' GROUP BY l.UPDATEAUTHOR, p.id;

??????bug????????jiraissue???SQL???

????????? ??????????????????????????????????

???? ? ???? ? ????? ? ???? ? ?????

????????????????????????????????????????????????

???? ?????????????????????????? 313782132?????????????????????????