What query string would you use to query when a Sprint has been updated?

[Bella Musial]

I am hoping that I can create a query that will show issues that have been pulled into a Sprint after the Sprint has been started.  For example: 

Sprint = 247 AND type != Sub-task AND Sprint CHANGED AFTER "2018/02/22"

However, History searches do not support the 'Sprint' field. 

Is this even possible in Jira? 

[Kurt Klinner]

@Bella Musial

Hi Bella

yes it needs to be added first (addedAfterSprintStart is a function that is provided by the add-on)

BR

[Bella Musial]

Is this available on the Jira Cloud?  I did have this on the server version if Jira, but this icon / option is not available on our view at this moment. 

How would I get the add-on? Is there a link to install? This is such a valuable option I don't see why it's not out of the box on the Jira Cloud.

[Kurt Klinner]

@Bella Musial

Hi Bella

the scriptrunner add-on provides an method addedaftersprintstart, that can be used within jql queries

https://scriptrunner.adaptavist.com/latest/jira/jql-functions.html#_addedaftersprintstart

Cheers

Kurt

[Bella Musial]

Thanks! Does the "add-on" needed to be added before this query will work? 

I get the following error when I try to use it: 

Field 'addedAfterSprintStart' does not exist or you do not have permission to view it.