Jql function for which sprint value changed

[Raju Mandapaka]

Hi Team,

I am having a scenario, one of our team member changing the sprint value before closing the sprint and assigning a new one.

Now is it possible to write a JQL to list out all stories for which sprint value changed from sprint (x) to sprint (Y).

Thanks in Advance

[Velizar Borisov]

Hi Seetham!

I would use the word "was" in the search query: 

"Sprint = y AND Sprint was x" 

Typically, that's the word for past values in the field, not sure if it would work.

Best regards,
Velio

[Raju Mandapaka]

Hello @Velizar Borisov 

Thanks for the response, but it is throwing a error "Error communicating with server"

if i refreshed the page its showing 500 error

Please refer screenshot

Please let me how can i proceed??

Thanks,

Raju

[Velizar Borisov]

Yeah, it doesn't work for me too.
I guess sprints, cannot be queried with this special word.

The last I can think of is to use the Automation addon, which was added not long ago in Jira, to copy the sprint name in the labels field (or a custom label field). That said you will have a container of all sprints your issue was part of.

If that doesn't work I'm affraid I'm completely out of ideas.

[Raju Mandapaka]

Hi @Velizar Borisov 

looks like it works but it will work for the issues after this automation was enabled, but what about the previous issues or completed sprints??

Thanks,

Raju