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 |