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;
Badges are a great way to show off community activity, whether you’re a newbie or a Champion.Learn more
An efficient enterprise content management system, or ECM, is a must-have for companies that create work online (cough cough, all companies). If content calendars, marketing plans, and bu...
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