list of User Stories Done by sprint with the info of the sprint during which the story has been put

[Malika ELKHARRAZ]

I need to find how can I get the list of User Stories Done by sprint with the info of the sprint during which the story has been put to "Done"/resolved. Indeed Jira shows several sprints nb in the "sprint" field ; (x ; y)=> for example when a story was selected during a sprint x and  done during the sprint z. I just need the sprint z info !

[Bill Sheboy · Accepted solution]

Hi @Malika ELKHARRAZ 

Some quick questions to help focus your solution approach ideas:

• How often do you need to do this: one time or repeatedly?
• How many projects do you need to do this for: one or many?
• What information do you need about the sprint: start/end, or some other information?
• What are you going to do with this information?

If you only need this infrequently for one project, I suggest you try the built-in sprint report.  You can see what finished for a specific sprint, and then change the sprint drop-down to select another sprint.

If you need more information and need to do this repeatedly, consider using the REST API or the Atlassian Excel plug-in to gather and analyze information, or investigate any marketplace add-ons which will meet your needs.

Best regards,

Bill

[Malika ELKHARRAZ]

Hi Thanks Bill,

My need is to track repeatedly and for one jira project the users stories done and its sprint resolution.

I need to count stories done by sprint and show the single sprint= the one the story has been resolved. That's it :)

I thought I could do it easily with JIRA gadget as it is a very simple and basic need :(. For example, the velocity report doesn't not fit the need...i tried to configure it to show count of done stories, but it counts twice a story when it didn't finished within the sprint but the sprint after.....

Sure I know I can do it with Excel plug in..I believe it's time consuming for a small feature. I need to learn more for REST API .. hope it is note the only solution

Best regards

Malika

[Bill Sheboy]

Hi @Malika ELKHARRAZ 

Thanks for clarifying!

One simple option is use the automation rule features.  You could do the following:

• When a sprint completes, have it send you an email with the list of issues completed
• If you wanted a better way to see what sprint an issue finished (for JQL filter-based reporting), you could also add custom field (e.g. Completed Sprint), setting the field when the sprint finishes.  You could then report on that field in the future.

To get you started, here is the documentation on the automation rules and the template library:

https://support.atlassian.com/jira-software-cloud/docs/automate-your-jira-cloud-processes-and-workflows/

https://www.atlassian.com/software/jira/automation-template-library#/label/all/1453

[Malika ELKHARRAZ]

Thanks Bill

I will try the custom field (e.g. Completed Sprint)

Regards

[Prince Nyeche]

Hi @Malika ELKHARRAZ 

Welcome to Community! Are you already using the Jira Software API? If yes, what endpoint to be exact? If no, what are the series of steps you've taken to get "sprint" field ; (x ; y) please elaborate.

[Malika ELKHARRAZ]

Hi, no I don't already use Jira Software API.

My need is very basic, I wish to see in the results of my query only the sprint nb during which the story was put in "Done" and I don't want other sprint nb. Since "Sprint" field returns on JIRA several sprint nb if the story has been started at a specific sprint and finished in another sprint...

thanks in advance