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;