I am looking for an addonn to provide an overview of all the projects with: number of issues, last time when an issue was created or modified, etc.
Anyone know any available?
If not a SQL query will help, specially one to get the time last issue was created/modified in a project.
Thanks in advance.
EDIT: I found this query provides the required data (postgres)
SELECT project.pname AS "Project", COUNT(*) AS "Issue Count", to_char(MAX(jiraissue.updated),'dd/mm/yyyy') AS "Last Update" FROM project INNER JOIN jiraissue ON project.ID = jiraissue.PROJECT GROUP BY project.pname ORDER BY "Project" ASC;
We're looking for participants for a workshop at Atlassian! We need Jira admins who have interesting custom workflows, issue views, or boards. Think you have a story to sha...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs