JQL to return plan in same order/heirarchy as Roadmap

[Barney Dalton]

Hi, 

I would like to be able to have a filter that shows my Roadmap issues in the same order as they appear on my plan. I am using ScriptRunner and have used the portfolioChildrenOf function to return both Initiatives and their children.

However if I order by RANK it doesn't respect the nesting I would see in the plan view. Instead I get a list of initiatives followed by a list of Epics. Is there a way to get back the ordering shown in the plan?

[Hannes Obweger - JXL for Jira]

Hi @Barney Dalton, 

I don't think that "native" filters can do that; JQL just doesn't have an understanding of parent/child relationships (outside of special function provided e.g. by ScriptRunner) and therefore won't apply the respective order.

May I ask what you ultimately trying to do with the filter? Perhaps there's other ways to achieve your goals.

[Barney Dalton]

I am trying to get an automated Excel/CSV extract of a plan. I have ended up extracting all the issues using the REST API and then re-creating the correct nesting within Python before saving to Excel.