Get JIRA issue status time

Question

There is a status in my JIRA instance called "Ready For Test" at which the tester would validate and close the jira. I need to know the amount of time the JIRA is in that particular status since it was moved from "In Progress" to "Ready to Test".

Is there a JQL query that can do it? I need this time field to be exported to Excel as well so that I can name and shame people and ask them to close the JIRAs as soon as they can.

Answer 1

Thanks @SilenyHobit for the idea. Here is what I've done:

1. First installed JIRA Suite Utilities plugin (its FREE)
2. Added a custom field called RFTDate (date type control)
3. Added a post function in RFT transition to update RFTDate with current datetime

Voila!!!