Forums

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

Reporting on recently breached SLAs with JIRA Service Desk

Jeff Sparks
Contributor
March 6, 2019

We have a Time to First Response SLA and a Time to Resolution SLA.  

I'm wanting to see any SLA breach within the past 7 days for any for either of these two SLAs regardless of the status of the ticket.  I'm using everBreached() and it looks like the I'm pulling back the correct info concerning breaches but when I add the 7 day argument if get tickets created months back.  Here is my current JQL:  

project = APSD AND status not in (Pending, "Waiting for customer") AND "Time to First Response" = everBreached() OR "Time to Resolution" = everBreached() AND created >= "-7d"

Any thoughts on a different or better way of doing this?

1 answer

0 votes
Ravi Sagar _Sparxsys_
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.
March 6, 2019

Try changing the OR to AND in your query.

Jeff Sparks
Contributor
March 6, 2019

Thanks for the suggestion.

I changed the date to 30 days to make sure I had a good sample.  

project = APSD AND status not in (Pending, "Waiting for customer") AND "Time to First Response" = everBreached() OR "Time to Resolution" = everBreached() AND created >= "-30d"

For 30 days with the above  JQL (with the OR) I get 94 results.

Changing the OR to AND gives me zero results.

project = APSD AND status not in (Pending, "Waiting for customer") AND "Time to First Response" = everBreached() AND "Time to Resolution" = everBreached() AND created >= "30d"

Ravi Sagar _Sparxsys_
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.
March 8, 2019

Are you referring to this JQL which is returning 0 results?

project = APSD AND status not in (Pending, "Waiting for customer") AND "Time to First Response" = everBreached() AND "Time to Resolution" = everBreached() AND created >= "30d"

 Try this.

project = APSD AND status not in (Pending, "Waiting for customer") AND "Time to First Response" = everBreached() AND "Time to Resolution" = everBreached() AND created >= "-30d"
Like Robbie likes this

Suggest an answer

Log in or Sign up to answer