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

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

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

...