JQL for issue resolved after Due date

kaysaff.tal May 11, 2020

Good morning, I am teying to run a JQL that will filter all issues that were resolved afetr duedate

2 answers

1 accepted

0 votes
Answer accepted
Walter Buggenhout
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
May 11, 2020

Hi @kaysaff.tal,

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

If you have scriptrunner in your instance, you can compare dates with a JQL query like this:

issueFunction in dateCompare("", "resolutionDate > dueDate")
kaysaff.tal May 11, 2020

Thanks for the quick answer! i will try with scriptrunner

kaysaff.tal May 11, 2020

@Walter Buggenhout  Script runner works! thank you

Walter Buggenhout
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
May 11, 2020

Great news, @kaysaff.tal. If this answer helped you, could you also accept it by clicking the Accept Answer button above? That way, it can also easier be found by community members having a similar question!

Thx! 

Dyego Mota June 22, 2021

too basic and jira doesn't support :(

Like # people like this
Abinaya Swaminathan May 10, 2023

@Walter Buggenhout It is the same for Next Gen projects as well? Do we still need an external application?

1 vote
Steve Howe July 19, 2021

You can use JIRA Automation as a workaround to find issues resolved after their due dates.

Setup an automation rule that is triggered when an issue is resolved, and have it automatically add a label of your choosing (we use "resolved-after-due-date") to the issue if the resolution date is after the due date.

Then you can simply query new issues by label to find issues resolved after their due date. If you wanted to backfill your existing issues with the new label, then you could adjust the trigger condition as needed.

Here's an example screenshot of this automation rule using the "Advanced compare condition".


automation rule.jpg

Dyego Mota July 19, 2021

in portuguese this is named "gambiarra" :(

Like # people like this

Suggest an answer

Log in or Sign up to answer