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

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.

Accepted answers

Jack Nolddor [Sweet Bananas]

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

All comments

Jack Nolddor [Sweet Bananas]

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

Welcome!

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

Quick Links

Find more posts tagged with

server

jira

jira-server