What query to track multi sprint stories/work items?

[Lori Nollet]

Trying to figure out how to build a query for work items that span multiple sprints.

[Matt Parks · Accepted solution]

Out of the box, I don't think Jira provides that functionality.

If you have Scriptrunner, you could create a scripted field that returns the number of sprints in a particular issue. The code is pretty simple.

import com.atlassian.jira.component.ComponentAccessor

import com.atlassian.jira.issue.fields.CustomField

CustomField sprintField = ComponentAccessor.getCustomFieldManager().getCustomFieldObjectsByName('Sprint').first() //grab the sprint field

def sprintList = issue.getCustomFieldValue(sprintField) //define the value

int total = 0 // declare total to 0

for (sprint in sprintList)

{

    total++

}

return total

[Lori Nollet]

Thank you!