View all Jira Service Desk tickets open longer than 2 weeks

[Barry Abrahamson]

Hi,

I would like to create a dashboard and a report for Jira Service Desk showing all tickets that have been open for longer than 7 days. There does not appear to be an easy way to do this - please can someone help?

[Nir Haimov]

Hi,

This is actually very easy to accomplish with JQL:

status = Open AND created <= -14d

You can add to it other parameters if you need (project, issuetype, etc...) 

[Bastian Stehmann]

Hi @Barry Abrahamson,

you can select the issues like this

created<-2w and status != Done

Maybe you will have to add the project or use another/more status, to make it work for you.

[Piotr Bojko]

JSD has SLA. Read this - https://confluence.atlassian.com/servicedeskcloud/setting-up-slas-732528967.html . 

This a best tool to be escalate such tickets automatically, not by hand (which I presume you want to do with a mentioned query).

With SLA you can automate a trigering email, escalate priority or simple view the new metric on the main dashboard for JSD project.