nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

JQL to show Tickets which cycled thru specific workflow status

Richard Rashty_rmmmrq

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....

Accepted answers

Kalyan Sattaluri_iinm1n

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()

All comments

Kalyan Sattaluri_iinm1n

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_rmmmrq

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_iinm1n

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-software-cloud

jql

jqlquerybuilder

status