Skip to main content
Skip table of contents

Finding No. Issues for every project

MySQL / PostgreSQL 

SQL
-- 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

ACC30

Issue Archiver

ARCHIVE 

211
SQL Reporter for JiraSQLREPORT142
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.