It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Aging of the issue in the current sprint

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? 

1 answer

0 votes
Jack Community Leader Jan 20, 2020 • edited

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().

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

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

Events near you