How do I query issues in an advanced roadmap and have them in the same order as the roadmap?

[Cash Coyne]

I have an Advanced Roadmap with this type of hierarchy:

Theme1

  Initiative1

    Epic1

      Story1

      Story 1.1

      Story 1.2

Theme2

  Initiative2

    Epic2

      Story2

      Story 2.1

      Story 2.2

I'm trying to get a list of stories and tasks in rank order.  But When I run this query:

issuetype NOT IN (MajorTheme, Initiative, Epic) ORDER BY Rank ASC

The stroies don't come out in the same order as I see on the screen in my advanced roadmaps.  This is true even if I include all issue types.

What am I doing wrong?

[Trudy Claspill]

Hello @Cash Coyne 

You are not doing anything wrong.

Advanced Roadmaps is capable of displaying the hierarchy. Filter results are not capable of displaying the issues based on the hierarchy.

You will not be able to get the filter results to show in the same hierarchical order that you see in Advanced Roadmaps. The order of the filter results is based exclusively on the ORDER BY clause of the filter.

Rank is a global value and each issue's rank is relative to the rank of the other issues. Rank is not per issue type but across all issue types. Rank has no inherent relationship to the issue type hierarchy. It is entirely possible for a child Story to have a higher Rank value than its own parent Epic.

[Cash Coyne]

We manage our projects with Advanced Roadmaps.  The order in which the issues are in Advanced Roadmaps is the priority (and not the Jira Priority field).  I'd like to be able to see them in other places in that order, like a board, or a query. Any thoughts on how to do this?  All I can think of is creating a numeric field called ARrank and we'd manually put a numeric value in there from 1.0 thru N.  But that's a bit onerous and if we move things around in the roadmap, we'd have to remember to change the issue's number. And I can't even figure out how to handle rearrangement as I can't figure out how to reference an issue that is above or below it after the rank changes.

[Trudy Claspill]

I apologize. I misread your question and missed the part where you said you wanted to get just the Story issues in the same order.

With that in mind, do I understand correctly that you consider the Stories in Epic 1 to all be a higher priority than the Stories in Epic 2?

If you moved Theme 2 above Theme 1 in your roadmap, would you want all the descendant Stories under Theme 2 to be ranked higher than the Stories in Theme 1?

[Cash Coyne]

@Trudy Claspill  Yes, that is correct