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!
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You are welcome @Sahar Rahgozar .
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.