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

How to find inactive, open tickets

Hi all, 

 

I'd like to know if there is a way to filter out open tickets that have been inactive for > 30 days, 60 days, 90 days (for example). My team sends out weekly reports outlining # of open tickets, # of tickets waiting for customer, # of tickets waiting on support, etc and I don't want that number to be skewed by resolved issues that haven't been closed for whatever reason. 

 

Is there a JQL to locate these tickets? 

 

Thank you in advance for your insight!

3 answers

Jira doesn't have the concept of "active" and "inactive" issues, but you can use the Updated Date to search for things that haven't been modified in a while.  Here is sample JQL that should point you in the right direction:

updated < 2019-09-30

Just change the date to the latest date you want to see. 

1 vote
Veera Atlassian Team Jan 17, 2020

Hi @Sahar Rahgozar 

Jira treats a ticket as open until the resolution value is set. Below JQL will give you all the open tickets which are not updated in last 30 days.

resolution is EMPTY AND updatedDate <= -30d

Hi @Dave Theodore [Coyote Creek Consulting]  and @Veera

Thank you both so much for the input! I tried the JQL that you've provided, and I was able to filter out open tickets that haven't been updated for 30+ days. 

 

Appreciate your help.

 

Best regards,

Sahar

Veera Atlassian Team Jan 20, 2020

You are welcome @Sahar Rahgozar . 

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