Is there a way to use JQL to calculate the transition time for a ticket in review?

Sourav Bhattacharya_9tyt87

Want to find the time taken for reviews in our project. Is there a way to use JQL or something else to find the time a particular ticket was in review phase.

The information is available under the Time in Source section under Transitions tab of a Jira ticket. But i want to find all tickets which has transition time in review state for more than a week?

Is this doable?

 

Petter Gonçalves

Hello Sourav,

In JIRA, the best free functionality that you can use to achieve this would be:

- Create a date/time custom field

-  Add the field to the screen in the In review transition

- Configure a post function in the In review transition that will automatically fill the custom field with the current date when the ticket is transitioned to In review status

- Performing the steps above, you will be able to search for issues that are currently In Review for more than one week with a query like this:

Status = "In review" and "custom date field" <= -1w

 

Otherwise, if you are using JIRA Server, you can use the plugin Time In Status to find this same information.