Aging of the issue in the current sprint

Piyush Dinde

Hi Everyone, 

I want to write a JQL which gives me issues for aging of the issue from the start date of the sprint. 

So I have written JQL something like this:

Project = X AND issuetype = Hotfix AND status != Closed AND created > -5 days AND sprint in OpenSprints() 

However this gives me overall aging of the hotfix issues wrt when they were created. 

What I want to check is how to find out the aging of the issue in current sprint and not from the date it was created? Can anyone help me with the query here? 

Jack Brickey

Hi Piyush,

unfortunately the start date of the sprint is not available for JQL. You might check addons for this but if memory serves others were unable to achieve with the ever-present Scriptrunner. I may be mistaken on that.

Now, what you could consider is creating your own custom date field, e.g. Current Sprint Start, and at the beginning of the Sprint you could set that date easy enough. Then you could create a filter to compare that date to say now() or startofday().