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

[Michael]

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

[Sushant Verma · Accepted solution]

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

[Michael]

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

[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 

[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]

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")