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; } } }

Is there a way to get a list of Issue that were ever in a particular status?

George Carvill

Our workflow has a status of "QA Final" from which an issue can transition to "QA Final Passed" and "QA Final Failed." Naturally, all issues don't go through the failed step. Nor do they end up there, because they get fixed, go back to "QA Final" and eventually pass.

The fact that the issue was once in the failed status is in the transition log.

I would like to get a list of the issues that were ever in the "QA Final Failed" status.

How can I do this?

Accepted answers

Jeff Thomas

Hey George,

You should be able to use the WAS operator to find those issues using JQL. Your query would be something long the lines of:

status WAS "QA Final Failed"

All comments

Jeff Thomas

Hey George,

You should be able to use the WAS operator to find those issues using JQL. Your query would be something long the lines of:

status WAS "QA Final Failed"

George Carvill

Yes! That works.

Now, is there a way to pull out the DATE it went into that status?

Luther Hargrove

I would do this through SQL. If you have access to the SQL database you can write a qeury to show issues that have ever had a history of 'QA Final Failed' as a status.

Tarun Sapra

Not sure whether it's possible through JQL, but using plugin you can get it on issue view screen and then through JQL -

https://innovalog.atlassian.net/wiki/display/JMCF/JIRA+Misc+Custom+Fields#JIRAMiscCustomFields-transitiondatefield

George Carvill

Thank you Jeff and Tarun. Jeff, your first "status WAS" answer was perfect. If I want to get dates, then I think Tarun's will work for that. I already have the plugin.

Jeff Thomas

I don't know if there is a way to find out the date that the status changed in using JQL. You can restrict your query to find changes based on the date though.

AFTER "date"
BEFORE "date"
DURING ("date1","date2")
ON "date"

Welcome!

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

Quick Links

Find more posts tagged with

jira

jira-administration