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;
Hi Adolfo,
You might use the table grid editor, and collect all the relevant statistics into a grid.
By creating it on a regular base you can then find out about trends.
It might be a good use case to further develop.
Francis
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.