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

Query for Resolved Date Difference and Rich Filter

Anand Vardhan_ivy9dj

Hi,

I'm looking for a query to find issues created after a certain date and whose resolved >3d than the created date of the issue.

Also, I'm trying to create a rich filter that would give me a list of issues along with created, resolved date and the last column will be "Number of Days to Resolution" which is difference between created and resolved date

Accepted answers

All comments

Mohamed Benziane

Hi @Anand Vardhan

Welcome to the community

Unfortunately you can't achieve this out of the box. Jql doesn't calculate difference between two date.

You can extract the filter and work on in excel. Or look for a plugin in the marketplace (i think scriptrunner can help you with custom jql functions)

Hope this helps.

Anand Vardhan_ivy9dj

Hey,

Thanks for the response!

I do have the scriptrunner plugin but not sure about the query.

Mohamed Benziane

You can try datecompare function below the doc

https://scriptrunner.adaptavist.com/5.6.7/jira/jql-functions.html#_dates

Anand Vardhan_ivy9dj

Would it give me the count?

Dan Mihalache _Qotilabs_

Hi @Anand Vardhan

I'm a member of the Rich Filters support team, so I can answer to your second question.

You need to create a Custom Value for your "Number of Days to Resolution", relevant documentation page available here, you have exactly this example.

Then you can define a View which includes created date, resolved date, the "Number of Days to Resolution" Custom Value and other fields that might be useful to you.

You can then use your view in a Rich Filter Results gadget.

Hope it helps.

Regards,

Dan

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

jql

filter