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 have multiple projects that use variations of the same base workflow. The variations depend on the requirements of the project or issue type. The variations mostly come in the form of new statuses ...
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