How to find inactive, open tickets

Question

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!

Veera_zqt9p1 · Answer

You are welcome @Sahar Rahgozar .

Sahar Rahgozar · Answer

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_zqt9p1 · Answer

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