Using Rank in JQL-question

[Jan Sjölund]

Hello,

I want create a query that extracts all my issues in my backlog including active and future sprints. The list shall be ordered by rank. The result will be exported to Excel for future manipulations.

"project in (xxx, yyy) AND component = zzz AND status not in (Resolved, Closed) AND issuetype in ("Change Request", "Trouble Report", Task) ORDER BY Rank ASC"

The problem I have is that the issues that are planned in a sprint (Active or future) do NOT have the highest rank in my query they can appear "random" in my resulting list.

How do I get a list that have the right Rank accordingly to my backlog view in my SCRUM-board?

[Petter Gonçalves]

Hello Jan,

Welcome to Atlassian community!

The order of the rank field should always respect the position of the issue in the Backlog/Sprint, unless your issues were inherited from previous Sprints or the rank field was manually changed.

That been said, when you say your Sprint issues does not have the highest rank, are you comparing it with your backlog issues or between the issues in the sprint itself?

If you are comparing with your backlog, you can order it by first by Sprint and them rank:

"project in (xxx, yyy) AND component = zzz AND status not in (Resolved, Closed) AND issuetype in ("Change Request", "Trouble Report", Task) ORDER BY Sprint ASC, Rank ASC"

Let me know if this information helps.

[Jan Sjölund]

Thanks.

"That been said, when you say your Sprint issues does not have the highest rank, are you comparing it with your backlog issues or between the issues in the sprint itself?"

In the backlog.

It seems that issues moved to a sprint, active or planned, will get a new rank that is only viable within that specific sprint and do not have any connection to the rest of my issues in other sprints or the backlog. 

 Yes, your solution would have worked perfect if we didn’t have old issues that have been part och closed sprints :( (bad planning and bad Jira usage, we are doing it better now :-) )

"All I want" is to export an exact copy of the view I see when I look at my backlog in my backlog-view that includes all sprints and the backlog.