Finding No. Issues for every project
MySQL / PostgreSQL
-- Issue Count Per Project
SELECT p.pname AS "Project Name", p.pkey AS "Project Key", COUNT(*) AS "No. Issue"
FROM jiraissue ji INNER JOIN project p ON ji.project = p.ID
GROUP BY p.pkey, p.pname;
Sample Result
Project Name | Project Key | No. Issue |
---|---|---|
Attachment Checker for Confluence | ACC | 30 |
Issue Archiver | ARCHIVE | 211 |
SQL Reporter for Jira | SQLREPORT | 142 |