JQL query

[Ayush Lawania]

How to create a JQL to show the tickets resolved within the 4hours, 8 hours, 12 hours and 16hours from the time of creation.

[Mohaddis Hassan]

Dear @Ayush Lawania You will get the desired result by changing the hours value.

[Ayush Lawania]

hey, it does not work, what i see with this jql is it shows all the issues created within last 4h, but what I am looking for is any issue which was created in any time frame but resolved within those time frames.

@Mohaddis Hassan 

[Mohaddis Hassan]

Hi, 

Yes, you are right the query will return all the tickets and there is no such query from which we can retrieve this except we can retrieve via automation rule attachment is attached below.
 

[Walter Buggenhout]

Hi @Ayush Lawania,

You tagged your question as related to Jira Service Management. If that is the case and you have a time to resolution SLA in place, you should be able to leverage that to answer your question.

The SLA timer should start when an issue is created and stopped when the issue is resolved. Once you have that, you can query this way:

resolution != unresolved AND "Time to Resolution" <= 4h

"Time to Resolution" would be the name of your SLA and you can play around with the 4h to track your different scenarios.

Hope this helps!