Report of items being assigned to multiple sprints

[Asha]

Hi,

Can I get a report of items that are moving between multiple sprints?

Thanks/asha

[Jack Brickey · Accepted solution]

Hi @Asha , Are you trying to find issues that do not complete in a sprint and roll over to a future sprint or are you saying that someone is actually entering multiple sprints into a single issue? Natively JQL does not provide a means of quiring for "more than one entry" in a field. There is a possibility that you could create an automation rule, and use the lookup and size functions to see if there is more than one value in the Sprint field but that is sort of a hack. There are third-party add-ons that would make this easier for you. However, maybe understanding the actual problem you are trying to solve, may reveal a different solution natively.

[Jack Brickey]

There isn't an easy way to do that, e.g. JQL.  However, here is a solution that could work for you going forward note that it will not find previous issues, though there is a variation that could do that as well. Create an automation rule as follows...

• trigger - when sprint completed for your board
• branch - for issues in sprint
• condition - JQL statusCategory != Done

Now for the Action component there are various solutions. The key is to somehow flag the issues as sprint carryover. Possibilities include: 

• Create a custom number field and you can increment that field each time an issue is carried over.  Alternatively, you could just make it a yes/no field if the number of times an issue is carried over is not important.
• add a label, e.g. "sprint-carryover"

[Asha]

Thanks, let me first try the automation rile.

The 2nd suggestion is more manual. 

Thanks for the response.  If there is a report that can be created in jira for this, it will help a lot

[Asha]

Thanks, I have set the automation rule.  Let me check in 2 weeks to see if this works fine.

Thanks a lot for the suggestion.

Asha 

[Asha]

Hi JAck,

I am trying to find issues that do not complete in a sprint but roll over to future sprints. 

In general, I can check every report and identify the same in a sprint review, but , over a period of time, I would like to check this from a project performance perspective.

Thanks/asha