Shulou(Shulou.com)06/01 Report--

After using JIRA, the BUG and functional development of all developed systems are recorded in the above process. When we want to make a statistical analysis of these massive data, such as counting the number of problems in each system, the number of questions submitted by testers every week and every month, the number of BUG developers deal with every month, and so on, we can even use these data for performance evaluation. Then, you can use SQL scripts to export data for special analysis by understanding the mysql table structure of JIRA's database. Reference script

SELECT pj.pname AS 'Project name', CONCAT (pk.PROJECT_KEY,'-', ji.issuenum) AS 'question label', ji.SUMMARY AS 'question subject', cg.AUTHOR AS 'Manager', cu.display_name AS 'Manager name' Ci.FIELD AS 'step state value', ci.OLDVALUE AS 'original state value', ci.OLDSTRING AS 'original state name', ci.NEWVALUE AS 'new state value', ci.NEWSTRING AS 'new state name' Cg.CREATED AS 'handle time' FROM changeitem ciLEFT JOIN changegroup cg ON ci.groupid = cg.IDLEFT JOIN jiraissue ji ON ji.ID = cg.issueidLEFT JOIN project pj ON pj.ID = ji.PROJECTLEFT JOIN project_key Competition ON pj.ID = pk.PROJECT_IDLEFT JOIN cwd_user cu ON cu.user_name = cg.AUTHORWHERE ci.FIELD IN ('status') ORDER BY pj.ID, cg.issueid desc, cg.CREATED desc

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.