JQL query to get the tasks which passed through a specific status

Question

Hi,

I would like to get a jql query to count how many tasks have passed through a specific status during a period, even whether they are not in that status when I launch the query

Thanks!

Bill Sheboy · Answer

Hi @PIERGIORGIO.RETTAROLI

I am glad that helped.  Please consider marking this question as answered; that will help others searching to find solutions faster.  Thanks!

PIERGIORGIO.RETTAROLI · Answer

Thanks Bill!

kind regards

Bill Sheboy · Answer

Hi @PIERGIORGIO.RETTAROLI  -- Welcome to the Atlassian Community!

Please try this JQL to find those tasks, substituting in your project name, status, and date range:

project = myProjectName
 AND status WAS "my status" DURING ("2021-01-01", "2021-01-20")
 ORDER BY Key

The query should return the list and you may see the count of items in the view also.

Best regards,

Bill