Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Query for Resolved Date Difference and Rich Filter

Anand Vardhan January 14, 2021

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

2 answers

1 vote
Dan Mihalache _Qotilabs_
Contributor
November 25, 2021

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

1 vote
Mohamed Benziane
Community Champion
January 15, 2021

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 January 15, 2021

Hey,

Thanks for the response!

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

Mohamed Benziane
Community Champion
January 15, 2021

You can try datecompare function below the doc

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

Anand Vardhan January 15, 2021

Would it give me the count?

Mohamed Benziane
Community Champion
January 15, 2021

Follow this link, it will give some instructions to create a field that will make the count for you.

https://www.idalko.com/use-script-runner-calculate-number-calendar-days-creation-resolution-issue/

Suggest an answer

Log in or Sign up to answer