JQL for Breached SLA

[Brandon Elie]

Hi,

I can see that you can filter for issues that have breached SLA targets, but can you filter for issues that are, for example 1 week or 1 month over SLA?

[Izabela França]

Hello, @Brandon Elie ! I hope you are doing well.

Try using both the everBreached() function and the elapsed() one, for example:"

"Time to Resolution" = everBreached() AND "Time to Resolution" > elapsed("40h")  (or the amount of time elapsed you would like to search for)

But that’s my take, at least. Interested to hear what others have to share!

[arielei]

Hey @Brandon Elie 
Yes, you can use the "elapsed" function to view work-items that have breached more than X hours.

for example

"Time to resolution" > elapsed("-24h")

see this document for more details:
https://support.atlassian.com/jira-service-management-cloud/docs/write-jql-queries-for-slas/

[Alina Kurinna _SaaSJet_]

Hi @Brandon Elie !

If you’re looking to get more flexibility with SLA filters and reporting, I recommend trying SLA Time and Report, an app developed by my team.

With our app, you can:

✅ Easily filter issues based on SLA status — whether it’s Met or Breached
✅ Use built-in charts like Met vs Exceeded to visualize SLA performance
✅ Filter by assignee, priority, project, team, and more – all in one view
✅ Add gadgets to your Jira dashboard for ongoing visibility

And yes, you'll be able to track breached SLAs, which are 1 week or 1 month overdue, with a simple filter or directly on the chart. No need to write complex JQL – it's already built into the interface.

Here’s an example of how the SLA chart looks in the app.

If you're curious, feel free to test it out or let me know. I'd be happy to help you get started!

[Rilwan Ahmed]

Hi @Brandon Elie ,

Try this JQL "Time to Resolution" >= elapsed("40h"). 

Valid durations for elapsed() is hours and minutes. Based on your SLA configuration and daily working hours, give the hours for week/Month. In my above query, I have used 40hours considering 8 hours per day and 2 days weekend.