Query regarding of closing time

Question

Hello,

how can I create a query when I wanna generally know how many tickets are closed within a certain time (e.g. 14 days)?

Thanks in advance!

mesons · Answer

Sorry, but it doesn't work the script function dateCompare! It also shows results whose updatedDate > 14d! I only would like to see the results whose time difference between createdDate and updatedDate is <= 14d!

Jack Brickey · Answer

ok so you are asking - "how many tickets are closed w/in 14d of being created?"

So OOTB there is date compare capability. You could accomplish this with an addon like Scriptrunner which supports date compare...

issueFunction in dateCompare("", "resolutionDate < created+14d")

you could also use the same addon to set the due date of all issues based upon create date and they use filter subscriptions or automation to notify when overdue.

there are other addon solutions, e.g. Power Scripts and Automation for Jira as well and the best solution depends on your requirement details. If you have one of these addons you are good to go. If not it is worth noting that A4J has a free version that would be worth installing.

mesons · Answer

For example I have a certain number of tickets (e.g. 100) and now, I wanna know how many of them has been generally closed within 14 days? Closing time refers to time between created and updated!