JQL filter for elapsed SLA counter

[SaidAslan]

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 

[Ignacio Pulgar · Accepted solution]

Try:

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

[SaidAslan]

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]

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

Use < 130m instead of -2h10m.

[SaidAslan]

yes thanks! it works correctly

[Ignacio Pulgar]

YW!