Versions Compared

Old Version 3

changes.mady.by.user Cao Liang

Saved on

compared with

New Version Current

changes.mady.by.user Hua Soon SIM [Akeles]

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

MySQL / PostgreSQL 

Code Block
languagesql
-- 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;

...