How do I query on a status of "QE Failed"

[Suzy Rothwell]

I am trying to determine via a query, the number of tickets that failed QE.  We tried multiple ways but Failed QE is not showing as a status and I cannot figure out how to locate tickets that at one time hit a "Failed QE" status.  Hopeful someone will have come across this and has a recommendation.  The ticket would be In QE but failed QE (see screen shot).

Thank you.

[Trudy Claspill]

Hello @Suzy Rothwell 

The text on the left is the name of the Transition between the current status of the issue and the Status values shown on the right. "Failed QE" is the name of the transition, and there is no way to query for issues based on the names of transitions.

You can query for issues based on whether or not they have transitioned from status "In QE" to status "In Progress", which would be an indicator that the "Failed QE" transition was executed. For that you would use the CHANGED operator. You can find details and examples of the operator usage here:

https://support.atlassian.com/jira-software-cloud/docs/jql-operators/#CHANGED

A statement like the following would get you the issues that had ever gone through the "Failed QE" transition.

status CHANGED FROM "In QE" TO "In Progress"

You can also add date information to the criteria to look for issues where that change happened during a specified time period.

Let us know if you have questions after reviewing the document.