How To View All Tickets In A Given Status

[Yusra Arshad]

Hello there!

I'm trying to generate a report that pulls a list of all the tickets that have ever been in our "Production Migration" status before closing, since the very beginning of our projects. (Tickets go through the workflow as either Open>Close or Open>Production Migration) 

I've tried the following expressions but no luck:

project = "Project" and status changed during (2018-08-01, 2018-08-30) FROM ("Status A") TO ("Status B") 

PROJECT = "Project Name" AND (STATUS WAS "Closed" AFTER "date1") AND (STATUS WAS "Closed" BEFORE "date2")

Project = “project” AND (status changed to “Status B”)

Project = “project” AND (status changed from “status A” to “Status B”)

Any advice/recommendations is much appreciated! 

[caglad · Accepted solution]

Try this 

status was "Testing (Stage)"

Replace Bold with your status