How to track the stories which are moved from one sprint to another?

bela shaji September 29, 2021

Can someone please help me with a JQL that gives me the stories that were moved from one sprint to another sprint ?

5 answers

3 votes
Alex Koxaras _Relational_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
September 30, 2021

Hi @bela shaji and welcome to the community!

You can achieve that in two ways:

  • By installing this app which has the previousSprint() function
  • Or by creating your automation :D

Creating an automation involves the creation of a custom text field and its placement on the appropriate screen (I would suggest only on the View issue opeartion). So let's call this field Previous Sprint.

  • Now you create a rule and choose as trigger the on value change
  • Select as a field "Sprint" and mark it to monitor only the "Edit" (I presume that this is what you want to monitor)
  • Now simply add an action to edit that issue and select the "Previous Sprint" field.
  • As a value insert this smart value {{#changelog.Sprint}}{{fromString}}{{/changelog.Sprint}}

find previous sprint.png

Now you are ready to create a filter with a JQL statement that "Previous Sprint" is not EMPTY. That will give you this list.

However, I would go an extra step further and create another rule to clear this field, when a sprint is completed. E.g. you complete a sprint, and for all the issues of that sprint clear the previous sprint value.

3 votes
Leo
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
September 29, 2021

Hi @bela shaji,

Welcome to community!

There is no straightforward to find issues which was in 2 sprints

but if you want to find an issue that was in closed sprint and also in current sprint then below query will help you out

project = KEY AND sprint in closedSprints() AND Sprint in openSprints()

hope this helps

 

BR,

Leo

0 votes
Hannes Obweger - JXL for Jira
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
February 28, 2024

Hi team,

if you're open to solutions from the Atlassian Marketplace, this would now be easy to do using the app that my team and I are working on, JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a number of so-called smart columns that aren’t natively available, including the number of sprints, the latest sprint, and many others. 

With these, you can build a view like e.g. this in just a couple of clicks:

number-of-sprints-v3.gif

As you can see above, you can easily sort and filter by the number of sprints. You can also use it across JXL's advanced features, such as support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting.

Any questions just let me know,

Best,

Hannes

0 votes
Daniel Turczanski - __JQL Search Extensions
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
October 14, 2021

Hi @bela shaji ,

With standard JQL, you can only get a list of issues that belong to closed, open, or future sprints - regardless of the board they belong to. 

You can also export the issues to Excel for further processing. This works if you want to do a one-off analysis.

Standard JQL doesn't easily allow it, but you can find the results quickly using our professional indexing service JQL Search Extensions

After you install the app, you can simply search:

issue in previousSprint("ACME board")
issue in addedToSprintAfterStart("ACME board")

Check out the documentation to see more examples.

I hope this helps!
Daniel

0 votes
Yuliia_Borivets__SaaSJet_
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
October 4, 2021

Hi @bela shaji 

You can try other solutions.

  • Filter issues that were not completed in the previous sprint with JQL like this:
project = MYPROJECT AND NOT status = Done AND Sprint = NN
  • Look for incomplete issues in the Sprint burndown chart.

But as not all of the incomplete issues might go to the next sprint, these two options above will not do the work for 100%.

  • Try solution from the Marketplace. Issue History will definitely help here. The add-on was developed by my team to detect any change in the issues list. You can easily get stories that were moved from one sprint to another. The list will look like this:

2021-10-04_10-16-33.jpg

Hope you will find this info helpful. 

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
FREE
PERMISSIONS LEVEL
Site Admin
TAGS
AUG Leaders

Atlassian Community Events