Finding Project Activity Level
MySQL
-- Project Updated last 30 days
SELECT project.pname AS "Project Name", COUNT(jiraissue.pkey) AS "Issue Updated Last 30 Days"
FROM jiraissue RIGHT OUTER JOIN project ON jiraissue.project = project.ID AND jiraissue.updated > NOW() - 30
GROUP BY project.pname
ORDER BY "Issue Updated Last 30 Days";
PostgreSQL
-- Project Updated last 30 days
SELECT project.pname AS "Project Name", COUNT(jiraissue.pkey) AS "Issue Updated Last 30 Days"
FROM jiraissue RIGHT OUTER JOIN project ON jiraissue.project = project.ID AND jiraissue.updated > NOW() - INTERVAL '30 DAY'
GROUP BY project.pname
ORDER BY "Issue Updated Last 30 Days";
Sample Result
Project Name | Issue Updated Last 30 Days |
---|---|
Attachment Checker for Confluence | 5 |
Issue Archiver | 16 |
SQL Reporter for Jira | 23 |