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?
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().
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events