Create
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Products
See all
Community resources
Top groups
Explore all groups
Community resources
Learn
Community resources
Events
Community resources

Query completed SLA higher than 40h

Thiago Di Giorg
Thiago Di Giorgio June 4, 2015

Hi Guys, I just changed my SLA metrics for Time To Resolution from 120h to 40h and now I would like to know, from the closed tickets, which of them has their Time To Resolution higher than 40h by querying JIRA using JQL.

 

Thanks

Answer
Watch
Like Be the first to like this
150 views

1 answer

0 votes
João Palharini
João Palharini
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
June 4, 2015

Hi Thiago!

There are two different queries that may achieve what you want. You may try both and check what suits you best:

"Time to resolution" = breached()

OR

"Time to resolution" < 0h

--
Cheers!

Joao

View More Comments
Thiago Di Giorg
Thiago Di Giorgio June 5, 2015

Hi Joao, neither of them worked.The first one will show me only the breached ones which in case of the closed tickets they met the SLA because was 120h but they took 100h, so its over 40h but at that time was less than the SLA. And the second query don't bring me any results, because when a ticket takes more than 40h the timer starts going down negatively. But thanks for your help.

Like
João Palharini
João Palharini
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
June 5, 2015

Sorry, my bad. I just edited the second query to another one. Could you try that instead?

Like
Reply

Suggest an answer

Log in or Sign up to answer
Jira
Jira Software
TAGS
AUG Leaders

Atlassian Community Events

    See all events