Skip to main content
Skip table of contents

Finding Project Activity Level

MySQL

SQL
-- 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

SQL
-- 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 Jira23
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.