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 ?
@NEGAR JALALIAN have you tried this ?
resolutiondate >= -1h order by updated DESC
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
yes I tried this @Moses Thomas it gives the list of issues resolved in last 1 hour
@Sreenivasaraju P can you give an example with scriptrunner how it will work ?
You can also use created and updated. To find issues that were resolved within two weeks of creation, use:
issueFunction in dateCompare(
""
,<span> </span>
"created +2w > resolutionDate "
)
https://jamieechlin.atlassian.net/wiki/spaces/GRV/pages/1212427/Scripted+JQL+Functions+With+Comments?focusedCommentId=23789594
Hello @NEGAR JALALIAN
This should do it
resolved >= -59m
Tested works for me.
@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 ?
@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
Hello, thanks i misunderstood
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
It looks like you're new here. Sign in or register to get started.
