Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

JQL for issue resolved after Due date

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

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")

Thanks for the quick answer! i will try with scriptrunner

@Walter Buggenhout _ACA IT_  Script runner works! thank you

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! 

too basic and jira doesn't support :(

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

in portuguese this is named "gambiarra" :(

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you