I want to write a jql query to find issues having due date after the resolution date. How to write

[Sanchit Kshirsagar]

In a project, we have stories with due date field and resolution date field at story level.

The story completion is due on xxx date. The resolution date however is some other yyy date. 

I want to compare whether due date xxx is how many days earlier or later from the resolution date yyy.

What jql query we can write.

[Jack Nolddor _Sweet Bananas_ · Accepted solution]

Hi Sanchit,

Sadly there is no way to query this kind of things using out of the box features. However, I believe using Script Runner for Jira you can type the following JQL within the advanced search:

issueFunction in dateCompare("project = 'My project' AND type = Story ", "resolutionDate > dueDate")

Regards

[Sanchit Kshirsagar]

Hello Jack, is script runner Available for enterprise version like ones adopted by the big companies and they using JIRA for the project management purpose?

[Jack Nolddor _Sweet Bananas_]

Yes, is available on both Server and Data Center deployment options :)