It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

JQL filter for elapsed SLA counter

hi there. 

can anyone help me to create a right jql filter? 

I need to search for issues with SLA "time to resolution" overdued (expired) more than 3 hours. 

status = "In progress" and "Time to resolution" > elapsed("3h") is not working 

1 answer

1 accepted

1 vote
Answer accepted
Ignacio Pulgar Community Leader Jun 30, 2016

Try:

status = "In progress" and "Time to resolution" < -3h

thanks, seems it work with std. 

and what about its bounds? looks like it takes issues in + - some minutes, isnt it? 

have issues with SLA Time to 2nd line reaction":

1) -2:06

2) -2:08

3) -2:09

4) -7:34

when I'm typing like (for additional custom SLA)

status = "Analysis 2nd" and "Time to 2nd line reaction" < -1h

result is all 4 issues. 

< 2h10m
result is all 4 issues. 
< -2h40m
result is all 4 issues. 
< -3h 
result is only 4) -7:34
is it right? 
Ignacio Pulgar Community Leader Jun 30, 2016

If you want to use minutes, the full unit should be in minutes:

Use < 130m instead of -2h10m.

yes thanks! it works correctly

Ignacio Pulgar Community Leader Jun 30, 2016

YW! smile

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted in Jira Core

How to manage many similar workflows?

I have multiple projects that use variations of the same base workflow. The variations depend on the requirements of the project or issue type. The variations mostly come in the form of new statuses ...

966 views 7 0
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you