As a Jira user, you're likely familiar with Jira's Service Level Agreements (SLAs) and how they can help teams track and improve their service delivery. However, finding the correct information within Jira can take time, especially when dealing with hundreds or even thousands of issues.
That's where Jira Query Language (JQL) comes in. With the right JQL queries, you can identify issues that have breached their SLAs, monitor SLA metrics, and more.
In this article, we'll go over 16 of the most popular JQL queries for SLAs in Jira. Whether you're a Jira administrator, team lead, or just a curious user, these queries will help you get the most out of Jira's SLA features.
š§ Now, without further ado, let's look at the most popular JQL queries for SLAs:
project = <Project name> and "Time to resolution" = breached()
"Time to resolution" != breached()
"Time to resolution" <= X(replace "X" with the desired value)
"Time to resolution" >= X
"Time to resolution" = X
"Time to resolution" != X
"Time to resolution" = paused()
resolution is not EMPTY
project = "Project Name" AND status != "Closed" AND "Time to resolution" <= remaining("X")
"Time to resolution" = breached() AND assignee = "User Name"
project = <Project name> AND "Time to resolution" = everBreached() AND status changed BY <User ID> AND status changed TO Done AFTER 'YYYY/MM/DD'
"Time to resolution" >= X AND "Time to resolution" <= Y (replace "X" and "Y" with the desired values)
assignee = currentUser() AND status != Resolved AND status != Closed
resolutiondate >= "YYYY/MM/DD" AND resolutiondate <= "YYYY/MM/DD"
project = <Project name> and priority=<your priority> and "Time to Resolution" = breached()
"Time to Resolution" <= remaining("0m") and "Time to Resolution" > remaining("-60m")
These 16 JQL queries are just the tip of the iceberg when it comes to SLA monitoring in Jira. And honestly, it was not easy for me (not a JQL person) to ensure that all of these JQLs were running correctly. Furthermore, a user question about "what JQL I should use for xxx" is one of the most popular themes in the Atlassian Community, so what about doing work a little simpler?
Allow me to introduce one of the third-party apps for Jira Cloud ā the SLA Time and Report add-on.
Using JQL and the Jira SLA reporting app, you can monitor SLAs in real-time and generate detailed SLA reports for your team and stakeholders. We hope these JQL queries and our add-on will help you achieve your SLA goals and improve your team's productivity.
If you're interested in exploring other time-saving add-ons, such as for Jira business process management, be sure to check out the Atlassian Marketplace. All add-ons by SaaSJet have a trial, so take advantage of the opportunity to try them.
Kateryna_v_SaaSJet_
1 comment