A Jira query to find all rollover tickets

[Carlie Barr]

Thanks in advance for any help you can provide. 

I am looking for a way to search all past tickets that have rolled over to another sprint for the year. I know you can see what has rolled over from a closed sprint to the current open one but I am hoping to find out a historical list of all rollover tickets. Can we search for any tickets that have advanced a sprint or more?

[Jack Brickey · Accepted solution]

HI @Carlie Barr , here is an option to consider. Use Automation to inspect the Sprint field for > 1 entries and send that info in an email. 

Note: I used Scheduled trigger simply so I could easily run at will from w/in Automations screen. My JQL finds issues resolved since first of the year. Add your email in the red area. The yellow provides the key info to include which I added below for ease of copying. 

resolved >= startofyear() and resolved <= endofyear() and Sprint in closedSprints()

Issues in multiple sprints:
{{#lookupIssues}}
{{#if(sprint.join("~").split("~").size.gt(1))}}* {{key}} -- {{summary}}{{/}}
{{/}}

*****credit where credit is due - I picked this up from @Bill Sheboy last year and saved into my personal automation library.

[Alexey Pavlenko _App Developer_ · Accepted solution]

Hi @Carlie Barr ,

Do you have ScriptRunner? Do you move all incomplete issues to a next sprint? If you so, you can do this

(issueFunction in incompleteInSprint("%YOUR_TEAM%", "%YOUR_SPRINTS%")) AND resolutiondate <= endOfYear() and resolutiondate >= startOfYear()

Or you can use the app I developed - Multi-team Scrum Metrics & Retrospective. With it, you can automatically get uncompleted scope across several years, half-years, quarters, months, or sprints for several teams/boards in a single view, and do drill-down (for example 2024 -> 2024 H1 -> 2024 Q1 -> 2024 Jan -> Sprint 1) to figure out where the issues really come from. If you would like to see them in the Issue Navigator. You can click on the 'View in Issue Navigator' button.

Also, you can:

• see the difference between periods—does the uncompleted scope increase or decrease for a certain period compared to the previous one?

• conduct in-place retrospections and after that collect the ordered reasons for why these issues were rolled over to next sprints. You can even compare periods or teams there against each other. This report can also be used for justifying budget allocations to solve one or another problem.
  
  
• track the same way any other metric (custom JQLs supported)
• and much more.

Best regards,
Alexey

[Trudy Claspill · Accepted solution]

Hello @Carlie Barr 

Welcome to the Atlassian community.

Jira does not have a native JQL function for that. Are you willing to consider getting a third party app to generate such a report?

Alternately you might be able to generate something through use of REST API calls.

[Carlie Barr]

Thank you!