i would like to pull the story report which has only multiple sprint, is there way to generate or check.
I'm also interested in this question.
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:
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
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
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!
But its shows 2 different records. i want see only more than one sprint mapped to same story
Would you please clarify what you mean by "its shows 2 different records"?
That JQL expression uses an AND keyword. Thus it will only return work items where each one has been in the multiple sprint states noted: open and closed.
If you want the exact count of sprints for each work item, you may use the automation rule approach suggested by @Dick or investigate marketplace apps which add calculated fields to JQL features.
@AkeshiAtoriato Welcome to the Atlassian community.
If you feel that a question has been answered, you also can vote for it as well. Just use the up-triangle next to the Accept answer button of the comment you want to support.
It looks like you're new here. Sign in or register to get started.
