Check if the ticket passed in certain status

[Jader Peixoto Volkmer]

Hi dears, 

I would like to create a filter to use on a Dashboard where I would like to know if the ticket passed in certain status in the workflow.

For example, the ticket maybe CLOSED but in its life cycle it passed in certain status, for exemple, "Reproved by QA". Is there a way to test if the ticket passed in the REPROVED BY QA status?

Thanky you,

Jader

[Mercy · Accepted solution]

JQL by itself cannot query a ticket’s full status history, so you can’t directly filter issues that *once* passed through “Reproved by QA” unless that status change was recorded in a searchable field. In Jira Cloud, the standard approach is to use the `status WAS` operator, which checks historical values stored in the issue change log. For example, a filter like `status WAS "Reproved by QA"` will return any issue that had that status at any point in its lifecycle, regardless of its current status ([JQL keywords](https://support.atlassian.com/jira-service-management-cloud/docs/jql-keywords/)).

[Jader Peixoto Volkmer]

Thank you very much, that's it.

Best

Jader

[Sam Okell]

You can achieve this through JQL, this would work

Status Changed To "Reproved by QA"

Add any other JQL you need around it and it should be good to go

[Natalia_Kovalchuk_SaaSJet_]

Hi @Jader Peixoto Volkmer !

You can use JQL to check what tickets ever passed through a specific status. For example:

It allows you to retrieve a list of tasks that were in the Reopened status (or, in your case, in Reproved by QA status), regardless of their current status. 

Also, if you’re considering third-party apps, I can recommend trying Issue History for Jira from my team. It can show every status the ticket has been in, along with timestamps and the person who changed it. Moreover, you can use the Status filter to retrieve a list of tickets in the required status. For example:

You can also filter tickets by specific projects, updaters, time ranges, keys, and field updates.

It allows you to easily see which tickets were in the Reproved by QA status, when, and who was responsible for the status change, even if they are now Closed.

Hope this is helpful!

[Jader Peixoto Volkmer]

Hi @Natalia_Kovalchuk_SaaSJet_ 

thank you.

I have used a JQL filtering Status using WAS Reproved by QA.

It worked well.

Rds.

Jader

[Rahul_RVS]

Hi @Jader Peixoto Volkmer ,

The WAS operator can get the information of a particular status in the workflow history of the issue. We have written a detailed article on the various JQL operators for time in status use cases, here

However for deeper insights, if you would like to try out a mktplace app, to analyze status transition dates, you might be interested in a mktplace app,

Time in Status Reports 

The below report can meet your requirement. Also the app has 20+ reports to meet a variety of use cases.

More details here.

Disclaimer : I am part of the app team for this add-on

[Jader Peixoto Volkmer]

Hi,

thank you for introduce me to  Time in Status app. That's not my need at this moment but it would be very useful for auditing the process. I am planning to working on it a little bit later.

Rds,

Jader