Jira Tips & Tricks
Some jira application tips, that you needed some time for performance analysis purpose.
1. Found inactive jira project that is last updated on 01/01/2015:
SELECT p.PNAME as "Project Name",p.pkey as "Project Key",count(i.id) as "# of issues",
to_char(MAX(i.UPDATED),'dd/mm/yyyy') as "Last Update Date",c.display_name||'('||p.LEAD||')' as owner
FROM jiraissue i,
project p,
cwd_user c
where p.ID = i.PROJECT and p.LEAD=c.user_name
HAVING MAX(i.UPDATED) < to_date('01/01/2015','dd/mm/yyyy')
GROUP BY p.pkey,p.LEAD,p.PNAME,c.display_name
ORDER BY MAX(i.UPDATED) ASC;
1. Found inactive jira project that is last updated on 01/01/2015:
SELECT p.PNAME as "Project Name",p.pkey as "Project Key",count(i.id) as "# of issues",
to_char(MAX(i.UPDATED),'dd/mm/yyyy') as "Last Update Date",c.display_name||'('||p.LEAD||')' as owner
FROM jiraissue i,
project p,
cwd_user c
where p.ID = i.PROJECT and p.LEAD=c.user_name
HAVING MAX(i.UPDATED) < to_date('01/01/2015','dd/mm/yyyy')
GROUP BY p.pkey,p.LEAD,p.PNAME,c.display_name
ORDER BY MAX(i.UPDATED) ASC;
Comments
Post a Comment