I have the following Issue Filter in JQL which gives me my backlog by rank order:
project = XXX and (type = Story or type = bug) and status != Closed order by rank asc
I'd like to have an equivilant SQL query so I can pull the same data directly in to an Excel spreadsheet. I know "Rank" is a linked list which requires some sort of a recursive SQL query.
Can anybody provide and example so I don't have to wrack my brain trying to figure this out myself.
This will give you a list of all the ids of the requested jiraissues and their current ranking:
select i.id,r.id from jiraissue i, AO_60DB71_ISSUERANKING r, project p where i.id=r.issue_id and i.PROJECT=p.id and p.PKEY = 'JC' and i.ISSUESTATUS not in (select id from ISSUESTATUS where pname in ('Closed')) and i.ISSUETYPE not in (select id from ISSUETYPE where PNAME in ('Story','Bug')) order by r.id;
Just change the 'JC' to your own project key.
SQL for JIRA does the job. Simply perform a query similar to this:
select * from issues where JQL='project = XXX and (type = Story or type = bug) and status != Closed order by rank asc'
Of course, you have to read the plug-in documentation in order to learn hot to export to a CSV format, but it is pretty easy too!
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