Querying Tarnsitions

[rishikesh kanap]

Is there a way to search for Transitions in JIRA? Need to figure out when a ticket got moved from open to in progress or from In progress to Testing or from testing to Closed.

[Aron Gombas _Midori_]

It is simple:

1. Open the issue 
2. At the bottom, under "Activity", click "History"
3. You can see all status changes (who made that when and from what old status to what new status)

[rishikesh kanap]

Thanks for the inputs!

We can see another option as Transitions however, this field is not available for querying. Looking for an option where it can be searched for multiple issues/tickets with a query. 

[Aron Gombas _Midori_]

"Transition" is not a field, but "status" is! And you can use the WAS operator to test it!

See here: https://support.atlassian.com/jira-software-cloud/docs/jql-operators/#WAS

These are part of native Jira features.

[RVS_Support]

Hi @rishikesh kanap 

We have built an app for this use case.

If you would be interested in the same, you can try out

Issue History Reports

You can view the complete change log for your filtered issues along with status changes as different columns.

Do Try it out.

Disclaimer : I am part of the team which developed this app

[Yuliia_Borivets__SaaSJet_]

Hi @rishikesh kanap 

This article might be helpful for your case: 6 simple options to track status changes in Jira

For status transitions, I recommend the first option (described in the article). Try JQL with the CHANGED operator. For example: 

status CHANGED FROM "To DO" TO "In Progress" AND status CHANGED FROM "In Progress" TO "On Hold" DURING (("2023/03/01","2023/04/01")

 Or the third option with Issue History for Jira app (developed by my team), where you can filter by specific status transition and get all changes for it.

Hope you find the solution that works best for you.