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

[Sourav Bhattacharya]

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 · Accepted solution]

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.

[Sourav Bhattacharya]

Thanks Petterson for the insight. I would take the first option in this case.

[Petter Gonçalves]

You are welcome, Sourav.

[Administrador de Jira GA]

Hello Petter, Because when you assign the validate, it assigns with a time lag, for 7 hours less.