How to check the story has multiple sprint

[Ramesh Krishnan]

i would like to pull the story report which has only multiple sprint, is there way to generate or check.

[Dick]

Hi @Ramesh Krishnan ,

If a story is in more than one sprint, the field sprint has more than one element (it's a comma separated string of names that has more than one entry). 

You can check this visually, or by means of automation:

• Just counting the number of comma's in the field, if it's more than 1, you have a story that has more than one sprint. 
• Converting the field content into a list see Atlassian docs on smart values - lists
  In particular the list.size command can help you, because that holds the number of array items for that field.

This check for elements in the sprint field should be followed up with a check if the sprint periods overlap, as a work item can be transported to a subsequent sprint if it's not finished. Conversion of the field to individual sprint names in a list is then beneficial, as you can access sprint parameters (like dates) this way: {{issue.sprint.startDate}}

Remember, sprints are coupled to boards. There can be only one sprint active per board. By keeping board filters "separate" (as in non-overlapping with regard to work items), you can mitigate having a story in multiple sprints simultaneously altogether.

Kind regards,
Dick

[Bill Sheboy]

Hi @Ramesh Krishnan 

Adding to the suggestions above...

When you only need to check if the work items in the current, active sprint have been in previous sprints, that may be checked with JQL functions:

project = myProject AND sprint IN openSprints() AND sprint IN closedSprints()

This would list the work items which have been in at least one closed sprint and the active one.

When the sprint has not started yet and there are future sprints, you could use that function instead.

Kind regards,
Bill

[Shalini Pradhan]

Hello @Ramesh Krishnan ,

Good day! Welcome to Atlassian Community :)

Jira’s native JQL does not support querying for "number of sprints an issue has been in. However, you can search for stories that have a non-empty Sprint field (i.e., have been in at least one sprint)

Query would be: issuetype = Story AND Sprint is not EMPTY

You can then export the results to Excel/CSV and check the Sprint column for entries with multiple sprint names/IDs (they are usually comma-separated)

Hope that helps, thanks!

[AkeshiAtoriato]

I'm also interested in this question.