JQL to find issues that transitioned from Open to closed under 12h

Question

Hello

I am trying to find a way to find how much time took some issues from Open to Closed status - like a SLA - need to close issues under 12h.

I am pretty much out of options.I tried changed from Open to Closed after 12h. Didn't work very well - pretty much missing some issues in In Progress for more than 2days - obviously missing the criteria.

Thank you for all the suggestions.

Horatiu Popovic2 · Answer

Hello - I am not looking for Service Desk neither for Script Runner. I am looking for JQL solution, for obvious reasons.

Ravi Sagar _Sparxsys_ · Answer

JIRA Service Desk comes with in built feature of SLA but if you have Script runner (which is amazing) add-on installed then you can create scripted fields that can have value calculated based on other fields.

Check here: https://jamieechlin.atlassian.net/wiki/display/GRV/Scripted+Fields#ScriptedFields-TotaltimethisissuehasbeenInProgress