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; } } }

How to filter to issues that were resolved after their due date?

Michael_qy22gs

Hi all,

I'm trying to setup a filter which only pulls in issues that were resolved / have resolution dates after their due date. I'm pretty knowledgable with JQL, but I just can't figure it out.

I am using the default system "Due Date" and "Resolved" fields for this filter. (No custom fields are involved)

Can someone please help me?

Thanks,

Mike

Accepted answers

Sushant Verma

Hi @Michael

Welcome to the community!

Unfortunately, there is no way to query this kind of things using out of the box features. There is an issue open for this that you can watch or vote for: JRASERVER-20727

However, I believe using Script Runner for Jira you can compare dates with a JQL query like this:

issueFunction in dateCompare("", "resolutionDate > dueDate")

Regards,
Sushant Verma

All comments

Sushant Verma

However, I believe using Script Runner for Jira you can compare dates with a JQL query like this:

issueFunction in dateCompare("", "resolutionDate > dueDate")

Regards,
Sushant Verma

Tim Perrault

Hi @Michael

Do you by chance have scriptrunner? If you do they have a JQL function that would be able to do it.

issueFunction in dateCompare("", "resolutionDate > dueDate")

That is the only thing I can think of off the top of my head.

Michael_qy22gs

We do have scriptrunner. Is there a way that the above JQL function can be avaiable to specific users / groups so they can create an issue filter / dashboard gadget off of it?

Thanks,

Mike

Michael_qy22gs

Hi @Tim Perrault & @Sushant Verma ,

We do have scriptrunner. Is there a way that the above JQL function can be avaiable to specific users / groups so they can create an issue filter / dashboard gadget off of it?

Thanks,

Mike

Tim Perrault

As long as SR is installed any user can use that function. Unless admins specifically turned off features in the plugin. Simple JQL should start returning the issues you need.

project = xxx AND issueFunction in dateCompare("", "resolutionDate > dueDate")

Sushant Verma

@Michael Yes, user can use that function and save the filter using the mentioned JQL.

These JQL Keywords can be used in the Issue Search screen when searching in Advanced mode.

Hope it will help you!

Regards,
Sushant Verma

Deepika Dandala

I could get the Due Date crossed items with this

issueFunction in dateCompare("", "resolutionDate > dueDate")

Is there a way that we can know and list by how many days the Due Date has been crossed?

Regards

Deepika

Welcome!

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

Quick Links

Find more posts tagged with

server

jira-software

jira-software-server

jql

filter