JQL Query for Issues about to Breach

[Ann Marie Lisak]

Hi, I want to find all Bug and Change Request issues that will breach within 30 minutes of SLA.  I wrote the following query:   

Project = X AND "Bug" <= remaining(30m) OR "Change Request" <= remaining(30m)

I have this query to display results on Dashboard in Swimlane but no issues are displaying.  Is there something incorrect with the query? 

I referenced this page:  Using JQL queries specific to SLAs | Jira Service Management Data Center and Server 5.11 | Atlassian Documentation

[Esteban Diaz · Accepted solution]

@Ann Marie Lisak , 

I guess that BUG is your Issue Type and ou need to specify which SLA is about to breach in your query... for example Time to first Response ....like this:

project = X and type = bug AND "Time to first response" <= remaining("30m") 

A little variation is:

 "Time to first response" <= remaining("30m") and "Time to first response" != breached()

I hope this has been useful to you.
I will be waiting for your comments. 😉

Cheers!

Esteban Diaz
https://www.linkedin.com/in/estebandiaz/ 

[Ann Marie Lisak]

Thank you Esteban! 

I will be searching for 2 issues types, Bugs and Change Requests in a particular project; practicing on one issue type. 

I created a filter with the following query and I got the issue that is about to breach:

Project = "JSM" AND "Bug" <= remaining("30m") 

When I wrote the query for the Dashboard /Swimlane, nothing displayed. 

I did refresh and I checked to see if I had any columns that needed to be added to the DB.    

Any other suggestions?  

[Mathew Lederman · Accepted solution]

Have you confirmed the query works in the Issue Navigator first? Is 'Bug' the name of your SLA or the Issue Type? If Issue Type, you'll need to know the name of the SLA you're checking against

If everything else is right, you may just need to add parentheses to clarify the request:

Project = X AND ("Bug" <= remaining(30m) OR "Change Request" <= remaining(30m))

[Ann Marie Lisak]

Thank you Matthew!  I'll try it with () too.  

[Mathew Lederman]

@Ann Marie Lisak I would definitely recommend confirming your Issue Type and SLA name. With the query I provided it assumes you have two SLA's. One called 'Bug' and one called 'Change Request'. Is this accurate? 

Best way to check this would be to look one of the issues you're trying to find. Both the Issue Type and SLA name should be clearly defined.

[Ann Marie Lisak]

Thanks Esteban.