JQL to show Tickets which cycled thru specific workflow status

[Richard Rashty]

i wish to know if there is a JQL that can show me the tickets that cycled thru a specific set of workflow statuses.  

for example,

1. the tickets that went from open to ready for qa, 

2. then tickets that went from ready for qa to ready for uat deployment

3. then tickets that went from ready for uat deployment to ready for pre-prod....

[Kalyan Sattaluri · Accepted solution]

Hello @Richard Rashty 

project = XXXX and status CHANGED FROM "Open" TO "ready for qa"

You could add additional qualifiers for date range.. Please look into WAS & CHANGED operators in below link:

https://support.atlassian.com/jira-software-cloud/docs/jql-operators/#WAS:~:text=WAS,endOfWeek()%20AFTER%20startOfWeek()

[Richard Rashty]

ty, for the idea....i  took it another step and used the STATUS WAS IN condition...to count the # tickets that were in the respective status 

Project = xxxx and created >= year-month-day AND Created <= year-month-day and issuetype = story and STATUS WAS IN ("ready for UAT". "ready for uat deployment")

[Kalyan Sattaluri]

Yes, those operators are great once you get familiar. I am still early stages.

Also, If you feel your post was clarified, consider accepting answer so others who are researching in future can find relevant info. Thanks!

[Bill Sheboy]

Hi Richard, and welcome to the Atlassian Community!

Yes, and...to the answer suggested:

Are you using a company-managed or team-managed project?  You may find that information at the bottom, left side of the page expanding area.

If you are using a team-managed project, there are known problems with the CHANGED operator in JQL when using the status names: https://jira.atlassian.com/browse/JRACLOUD-78387

The work-around is to use the status id value to specifically select the ones you want.

Kind regards,
Bill