how to search the jira that have been turn to specific status in specific time period?

[雅 高]

for example, i want to search all the jiras that are once turned to "in testing" within 7 days (maybe they are not in "in testing" status now, but i dont care), how should i setup the filter?

[Ste Wright · Accepted solution]

Hi @雅 高 

You can do this using JQL's history functions, but can I clarify what you want to see, is it:

• Any issue that is or was "In Testing" in the last 7 days or...
• Any issue that was transitioned to "In Testing" in the last 7 days

There is an important distinction here.

----------------

If you want to see all issues that are or were "In Testing" in the last 7 days, you could use:

status was "In Testing" AFTER -7d

But, this will show issues that were "In Testing" and no longer are, alongside all issues "In Testing". This would be every issue regardless of when it was transitioned to "In Testing" (eg. an issue transitioned 6 months ago).

----------------

If you only want to see issues that were transitioned to "In Testing" in the last 7 days, you need to discount all the others already in "In Testing" before a week ago. Then I would use:

status was "In Testing" AFTER -7d and status was not "In Testing" BEFORE -7d

----------------

You could replace -7d with a date if preferred (eg. 2021-03-01). 

----------------

This is for Classic projects; for Next-Gen, you need to reference the Status' ID via JQL, rather than its name. This is because each Status in Next-Gen is unique per project (even when two projects' have the same Status).

A Status' ID can be located via the REST API - if your project is Next-Gen, let me know and I'll provide instructions!

----------------

Let us know which query works for you!

Ste

[雅 高]

this great, your answer really helped

[Brant Schroeder]

@雅 高 Welcome to community.  You can use Advance Search Functions

You can use the JQL status WAS "In Testing" AFTER "2021/03/18"

This will only work on Classic projects and not Next-Gen

[雅 高]

thankyou very much. it worked.