Find all issues that were overdue during this month

[Javanshir Mustafayev _ HIT]

Hi,

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?

[Javanshir Mustafayev _ HIT · Accepted solution]

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

[Javanshir Mustafayev _ HIT]

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

[Andrea Pannitti]

Hi @Javanshir Mustafayev _ HIT,

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

[Javanshir Mustafayev _ HIT]

@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.