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;
I'm John Allspaw, co-founder of Adaptive Capacity Labs, where we help teams use their incidents to learn and improve. We bring research-driven methods and approaches to drive effective inciden...
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