Sprint has Changed

[Melissa C]

Hello,

I'm looking for JQL that will show when an issues sprint has changed. 

I'm not sure if this is possible using JQL. I have done an extensive search and I don't seem to find anything reliable. 

The requirements is Show all issues where the sprint has changed 

Melissa

[Trudy Claspill]

Hello @Melissa C 

I can confirm that there is not a native JQL function/statement that can be used to find issues where the Sprint field has been changed.

What is the actual problem you are trying to solve? Why do you need to find issues where the Sprint has changed?

There are a variety of reasons that the Sprint field could be updated for an issue.

1. The issue is added to a sprint for the very first time.
2. The issues is removed from a sprint
3. The issue is not completed in its current sprint and gets added to another sprint

[Scott Schellhardt]

Great point Trudy. Adding additional conditions will help further define the scope for the desired result ! 

[Scott Schellhardt]

Hi Melissa,

Im not sure theres a direct way to do this but you could try doing some sort of automation to capture the change (ex. IF Sprint value changes then add label to ticket) and run a JQL on the label(ex. rollover) thats applied. Thats what I would do at least. Hope this helps. 

[Melissa C]

Hello @Scott Schellhardt 

We also had that idea! 

Then I guess we would have to remove that label, it seems like a mess to clean up.  Haven't fully thought it thru yet.

Melissa

[Dan -minware-]

Disclaimer: marketplace partner!

@Melissa C As others have mentioned I don't think this is possible with JQL but if you are open to working with a 3rd party we can help at minware. 

Here is an "out of the box" report showing tickets added / removed. If you wanted to look at specific dates / times or visualize the time series differently its super easy with our query language minQL:

We offer a free trial if you want to check it out!

[Yuliia_Borivets__SaaSJet_]

Hi @Melissa C 

In Jira JQL only works for six fields to show past changes: Assignee, Fix Version, Priority, Reporter, Resolution, Status. It doesn't work for Sprint.

To see sprint changes, you can try automation as suggested in the previous answer.

To get sprint changes for all issues in one place, you can also check Issue History for Jira (app developed by my team).  

It is possible to filter changes for the specific field, for example, sprint: