nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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?

Accepted answers

Javanshir Mustafayev _ HIT

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

All comments

Andrea Pannitti_ydvlwe

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.

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

Javanshir Mustafayev _ HIT

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud