JQL filter for duration of resolved less than an hour

[NEGAR JALALIAN]

Hi 

I have been trying to find a a way to make a JQL filter to get a list of issues which have been resolved less than an hour . which means resolved - created is less than 1 h .

haven't been successful . anyone knows ? 

[Olga Videc]

Hello @NEGAR JALALIAN 

This should do it 

resolved >= -59m

Tested works for me.

[Canal Digital SLM]

@Olga Videc  no it only list those issues resolved in last 59 min ago . what I need is duration of resolving an issue is less than 1 hour

[Olga Videc]

Hello, thanks i misunderstood

[Olga Videc]

Like @Sreenivasaraju P  said scrip runner

Maybe this helps 

https://community.atlassian.com/t5/Jira-questions/ScriptRunner-quot-Resolution-time-quot-scripted-field-Cannot/qaq-p/762355

And then you can filter based on this field

A second possible solution if you use service desk

Create an SLA "TIme to Resolution"  set it to 1h and if this SLA is breached the issue is not resolved within an hour

[Sreenivasaraju P]

Hi @NEGAR JALALIAN ,

Out of the box, this is not available. You can any third party plugin like script runner. 

Refer

https://community.atlassian.com/t5/Jira-questions/JQL-Query-to-Find-Issues-Resolved-On-or-Before-Due-Date/qaq-p/345820

[NEGAR JALALIAN]

@Sreenivasaraju P  can you give an example with scriptrunner how it will work ? 

[Sreenivasaraju P]

You can also use created and updated. To find issues that were resolved within two weeks of creation, use:

issueFunction in dateCompare("", "created +2w > resolutionDate ")

Refer 

https://jamieechlin.atlassian.net/wiki/spaces/GRV/pages/1212427/Scripted+JQL+Functions+With+Comments?focusedCommentId=23789594

[Moses Thomas]

@NEGAR JALALIAN   have you  tried this ?

resolutiondate >= -1h order by updated DESC

[NEGAR JALALIAN]

yes I tried this @Moses Thomas  it gives the list of issues resolved in last 1 hour

[Moses Thomas]

@NEGAR JALALIAN  Well i don't  see how you  are able  to  filter  in  this sense

resolved - created is  1 hour  less. I was thinking about dateCompare()

Could your really  explain  less  than an  hour ?