Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Tracking Aged Tickets

Siddharth Saire May 23, 2018

Hello,

Need a query which can help me pull records of the open issues that had been created 5 days earlier, so I can track the number of issues that have aged more than 5 days of their creation. 

1 answer

1 accepted

1 vote
Answer accepted
Claudiu Lionte
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
May 23, 2018

Hi Siddharth,

 

Here's the JQL for it:

createdDate < startOfDay(-5) 

Of course, you can add more filters to this like

createdDate < startOfDay(-5) AND issuetype = Bug

then you can order by createdDate either ASC or DESC 

 

Cheers,

Claudiu

Siddharth Saire May 25, 2018

Thank you so much @Claudiu Lionte this is helpful !

Suggest an answer

Log in or Sign up to answer
TAGS
atlassian, ace, atlassian community event, donation, girls who code, women in tech, malala fund, plan international, kudos, community badge, badge, atlassian badge, International Women’s month, International Women’s Day, women's month, women's day

10 for Change at Atlassian Community Events

Show up and give back by attending an Atlassian Community Event: we’ll donate $10 for every event attendee in March!

Join an Atlassian Community Event!
AUG Leaders

Upcoming Jira Events