JQL for issues resolved within "x" days of created date

Fubha Burney January 31, 2019

I would like to fetch issues which are being resolved within 3 days of their respective created date.

If we have;

  • Issue 1: Created 1st Jan - Resolved 3rd Jan
  • Issue 2: Created 1st Jan - Resolved 5th Jan

The jql would show issue 1 but not issue 2

I want something like;

issuetype = Bug AND priority = "Urgent " AND Env = production AND resolved <= (created + 3d) ORDER BY created DESC

Is this possible?

1 answer

1 accepted

0 votes
Answer accepted
Thomas Deiler
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
January 31, 2019

Dear @Fubha Burney,

with standard Jira mechanism, it is not possible to request something like

"give me all issues where the resolved date is not more than +3d from the created date",

because you cannot compare two fields with each other. Therefore you will need a plugin.

So long

Thomas

Fubha Burney January 31, 2019

@Thomas Deiler, do know of some plugin with which it can be achieved?

Thomas Deiler
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
January 31, 2019

The big one, called script runner. Probably there are others.

Kasi Maddula July 28, 2022

@Thomas Deiler  Yes, we are also facing same issue to run the query to get the output, can you please suggest any related plugin except eazyBI

Suggest an answer

Log in or Sign up to answer