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
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 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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hey,
Thanks for the response!
I do have the scriptrunner plugin but not sure about the query.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You can try datecompare function below the doc
https://scriptrunner.adaptavist.com/5.6.7/jira/jql-functions.html#_dates
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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/
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.