Forums

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

How to create a JQL filter to find the list of issues that are resolved before/ after due date?

Malavika L P April 27, 2022

I wanted to run a JQL query that helps me get the list of issues that are resolved/closed before or after the due date mentioned in the issue

1 answer

0 votes
Dave Mathijs
Community Champion
April 27, 2022

Hi @Malavika L P welcome to the Atlassian Community!

Unfortunately, Jira does not support this functionality natively. There is an issue open for this that you can watch or vote for: JRASERVER-20727  

With third-party app ScriptRunner for Jira, you can use the following JQL:

issueFunction in dateCompare("", "resolutionDate > dueDate")
Malavika L P May 3, 2022

thanks Dave ..I found another method to set an automation rule for the same

Like Dave Mathijs likes this
Dave Mathijs
Community Champion
May 4, 2022

Care to share your automation solution?

Malavika L P July 1, 2022

Hi Dave,

Sorry for the late reply I was able to generate the below rule successfully. Attaching the same if it might be helpful for you

Automation.png

Suggest an answer

Log in or Sign up to answer