Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Querying Tarnsitions

rishikesh kanap June 27, 2023

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.

3 comments

Comment

Log in or Sign up to comment
Aron Gombas _Midori_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
June 28, 2023

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)

-CARCHC-799-Remove-invalidation-space-property-related-code-everywhere-Jira.png

rishikesh kanap June 28, 2023

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_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
June 28, 2023

"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
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 28, 2023

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

Issue History.PNG

Yuliia_Borivets__SaaSJet_
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
June 28, 2023

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.

status transitions in Jira.png

Hope you find the solution that works best for you.

TAGS
AUG Leaders

Atlassian Community Events