Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Looking for query of all tickets not updated withing x minutes from creation time

Fred_Cheshire
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
February 24, 2020

I'm looking for a way to query all tickets from the startOfMonth() that have not been updated within 30 minutes of the created time.   Basically we have an OLA that all tickets hitting our board will be touched within 30 minutes.  I need to know how many each month that go over. 

2 answers

0 votes
Daniel Turczanski - JQL Search Extensions
Atlassian Partner
April 6, 2020

Hey, you can do it with JQL Search Extensions

hasSameUpdatedAndCreatedDate = "true" and created < -30m
0 votes
Payne
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 25, 2020

If you're talking about service desk issues, then SLAs are an option. We have one named Time to First Response that starts counting when the issue is created and stops when one of several possible actions occurs (customer-visible comment made, entered status To Do, etc.) It has a goal of 3 hours. We then have a report configured for SLA success rates that we use to identify the percentage/count of failures, and we can dig into the failures to review the details.

Fred_Cheshire
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
February 26, 2020

We’re not using Service Desk

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events