Hello community! Is there any way to have a filter that shows me the tickets resolved in the current month that were resolved after due date?
I've done this exporting the tickets on sheets with a formula resolution date <= due date but i couldn't find it on Jira.
Thank you!
JQL doesn't offer a 'date compare' out of the box. You can compare to some relative date functions such as startOfDay(-3d) and such. But comparing two date fields like Resolution date and Due date is not possible.
So, as a work-around, you could create an automation rule, scheduled to run each month. This rule would compare the resolved date with due date. And in case the resolved date is > due date, the rule can add a label 'resolved_after_due'.
Once this rule has run, you can create a report filtering on issues with the label 'resolved_after_due'.
Have a nice day! Rik
Thanks for the reply! I will be testing that.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Rik, I did the automation rule and worked just fine! but now I have this problem: When the resolution date is the same day as the due date I don't want it labeled as after due, this is because it's counting hours, minutes and seconds. Do you know a way to solve this?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
In the automation rule you can use an Issue feld compare. For example, the rule can trigger on transition to Done.
And then the rule can check if the Due date is BEFORE the moment o firing the rule.
I haven't tested this, but I think this should do the trick.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
That made it!
You are the best Rik, thank you very much, have a nice weekend!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hey There! You should be able to find them using JQL, give this a shot.
due <= "0" AND resolved <= "0"
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello, I tried this but didn't work. Thank you!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks for the reply!
I've tested the above and confirmed my results. If you split the query in half, you should be able to test which portion is giving you trouble.
A simple search of
due <= "0"
Will give you overdue tkts regardless of status.
The second half will filter for all those tkts resolved after that date.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I used the expression on a filter, but it's giving me wrong results. I missed something?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I’m Charlotte, a support engineer at Appfire and I’m here to help you.
Unfortunately, using vanilla JQL, you’ll not be able to do it dynamically.
In the app where my team works, JQL Search Extensions for Jira, you can use this query find issues resolved in the current month that were resolved after due date:
issue in dateCompare("duedate < resolved") AND resolved >= endOfMonth(-1)
Please contact our support if you have any other questions about this query.
We’ll be happy to help you!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi! thanks, your app looks great but im looking for a free way to get this done. Thanks anyway!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.