Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Advanced Search using JQL: tickets that got to resolved within 5 days from creation date

Venkat/ Prabesh (Natera IT) July 11, 2018

Objective: Total No of tickets resolved within 5 days

I am not able to do the following criteria JQL :

created date - updated date < 5 and status = resolved.

- Appreciate any other ideas that I can try.

1 answer

0 votes
Andy Heinzer
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
July 13, 2018

Natively Jira can't do this kind of date comparison where you want to dynamically compare two different fields of each issue.  There are other plugins for Jira that can help here.  The one I am aware of that can do this is Scriptrunner, but I'm confident there are also other alternatives that can do this as well.

Specifically you can take a closer look at their expanded JQL functions such as dateCompare.   With this plugin I suspect you could do something like this in Jira's JQL search:

issueFunction in dateCompare("", "created +5d > resolutionDate")

In turn I would expect this to return all issues that were resolved within 5 days of their creation.   I hope this helps.

Andy

Suggest an answer

Log in or Sign up to answer