...
| Code Block |
|---|
-- 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.PROJECTproject = p.ID GROUP BY p.pkey, p.pname; |
...
| Project Name | Project Key | No. Issue |
|---|---|---|
Attachment Checker for Confluence | ACC | 30 |
Issue Archiver | ARCHIVE | 211 |
| SQL Reporter for Jira | SQLREPORT | 142 |
...