MySQL / PostgreSQL
Code Block |
---|
-- Issue Count Per Project SelectSELECT p.pname asAS "Project Name", p.pkey asAS "Project Key", countCOUNT(*) asAS "No. Issue" FROM from jiraissue ji innerINNER joinJOIN project p onON ji.PROJECT = p.ID groupGROUP BY 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 |