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

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?

3 answers

1 accepted

3 votes
Jeff Thomas Atlassian Team Feb 26, 2014

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"

Yes! That works.

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

Tarun Sapra Community Champion Feb 26, 2014

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

Jeff Thomas Atlassian Team Feb 26, 2014

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"

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.

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.

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

3,096 views 13 18
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot