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

Check if the ticket passed in certain status

Jader Peixoto Volkmer_r5c09o

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

Accepted answers

Mercy_dt1a1g

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

All comments

Mercy_dt1a1g

Jader Peixoto Volkmer_r5c09o

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

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

TIS - Status Transition Details.PNG

Jader Peixoto Volkmer_r5c09o

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

Natalia_Kovalchuk_SaaSJet_

Hi @Jader Peixoto Volkmer !

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

Frame 1 (21).png

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:

status-ih (1).png

status-ih (2) (1).png

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_r5c09o

Hi @Natalia_Kovalchuk_SaaSJet_

thank you.

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

It worked well.

Rds.

Jader

Welcome!

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

Quick Links

Unanswered
Groups
Help

Find more posts tagged with

jira

cloud

jira-service-management-cloud

jira-service-management