Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

Find all issues that were overdue during this month


I’m trying to find all Jira issues that were overdue during this month

How do I search these issues with a JQL? 
The second problem I’m trying to resolve is if an issue was overdue and the due date got changed I still want to see the issue filtered using the JQL, is this possible?

3 answers

1 accepted

The scheme I've provided in my reply works as a solution for me

What if I create a custom field Overdue (true/false) and filter the issues by this parameter, which I will handle to set true if the due date passed?

Two scenarios here:

The issue is overdue the custom field flag is up and it is filtered as an overdue issue no matter what happens.

I can allow editing this field only for admins.

The second scenario is when a manager asks to remove the flag, then I edit the flag with the approval of a C-Level manager to change the flag and then it isn't filtered in the overdue filter.

Please correct me if I'm wrong.

Will this work?

P.S: if the issue needs to be done in the next month (we have monthly KPI's based on this metrics) , I will suggest the users to clone the issue with a new due date

Hi @Javanshir Mustafayev ITL,

if you use ScriptRunner, there are a few of useful JQL functions that can be useful to solve your issues.

@Andrea Pannitti 

Thanks for your answer, but we only use JMWE now and there are no plans for ScriptRunner in the near future.

I would like to resolve this using out-of-the-box features even if it takes my time to implement a complicated solution.

Suggest an answer

Log in or Sign up to answer
Site Admin
Community showcase
Published in Jira Software

An update on Jira Software customer feedback – June 2022

Hello Atlassian Community! Feedback from customers like you has helped us shape and improve Jira Software. As Head of Product, Jira Software, I wanted to take this opportunity to share an update on...

146 views 2 5
Read article

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