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

Question

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?

Cash Coyne_tanpr0 · Answer

@Trudy P Claspill  Yes, that is correct

Trudy P Claspill · Answer

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_tanpr0 · Answer

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.