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!
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.
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