Versions Compared

Old Version 1

changes.mady.by.user Ferry China

Saved on

compared with

New Version 2

changes.mady.by.user Cao Liang

Saved on

Key

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

...

Code Block
-- Project Updated last 30 days
SELECT     project.pname asAS "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 RIGHT> OUTERNOW() JOIN- 30 GROUP BY project.pname ORDER BY "Issue Updated Last 30 Days";

PostgreSQL

Code Block
-- 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.PROJECTproject = project.ID AND jiraissue.UPDATEDupdated > nowNOW() - 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