Tickets resolved after due date

Juan Ignacio Tallarico
Contributor
March 6, 2024

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!

3 answers

1 accepted

5 votes
Answer accepted
Rik de Valk
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 6, 2024

Hi @Juan Ignacio Tallarico , 

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

Juan Ignacio Tallarico
Contributor
March 6, 2024

Thanks for the reply! I will be testing that.

Like # people like this
Juan Ignacio Tallarico
Contributor
March 7, 2024

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? 

Rik de Valk
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 7, 2024

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. 

Screenshot 2024-03-08 at 08.25.15.png

I haven't tested this, but I think this should do the trick. 

Like Juan Ignacio Tallarico likes this
Juan Ignacio Tallarico
Contributor
March 8, 2024

That made it!

You are the best Rik, thank you very much, have a nice weekend!

Like Rik de Valk likes this
1 vote
mruttan March 6, 2024

Hey There!  You should be able to find them using JQL, give this a shot.

 

due <= "0" AND resolved <= "0"
Juan Ignacio Tallarico
Contributor
March 7, 2024

Hello, I tried this but didn't work. Thank you!

mruttan March 7, 2024

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. 

Juan Ignacio Tallarico
Contributor
March 7, 2024

I used the expression on a filter, but it's giving me wrong results. I missed something?Captura de pantalla 2024-03-07 114653.png

0 votes
Charlotte Santos -Appfire-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 7, 2024

Hi @Juan Ignacio Tallarico 

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!

Juan Ignacio Tallarico
Contributor
March 7, 2024

Hi! thanks, your app looks great but im looking for a free way to get this done. Thanks anyway!

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events