Bugs in status open across different period of time

[Doron Avisar]

Hi,

I'm trying to create a query that will show me how many bugs were in status open at a specific time in the past, any idea how to create such a query?  

[Ashish Bijlwan]

Hi @Doron Avisar 

Welcome to the Atlassian Community!

Please use the JQL issuetype = bug and status was Open and created >= '2023-01-20' and created <= '2023-01-25', it will show the all the Bugs that were in the Open status which are created between 20th Jan to 25th Jan 2023. You can change the date range as per your need.

Thank you,
Ashish

[Doron Avisar]

Thanks Ashish. I think the following is what i need:

status was in (Open,"Under Investigation","Pending Info",Blocked,"In Review","Pending repro","IN PROGRESS") ON 2023-01-01