Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Current »

MySQL / PostgreSQL 

-- 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
  • No labels