How many bugs where completed during a specified time period

[Marcus_palm]

Hi, 

I'm trying to write a JQL Query that can give me a list of bugs, that where moved to Done, given a timespan. But my limited knowledge of JQL is getting me stuck. 

What I'm trying to do: 

project = APPEN AND issuetype = Bug AND status changed to "Done" FROM "date" 2023-11-10 to 2023-11-22 order by created DESC

Anyone here that could help me write this query correctly? 

Thanks in advance! 

[Ste Wright · Accepted solution]

Hi @Marcus_palm 

This should work:

project = APPEN AND issuetype = Bug AND status changed TO Done DURING (2023-11-10, 2023-11-22)

This does assume you want all issues (whether still in Done or not) - or if you only want issues still in Done, you could add that in after Bug:

project = APPEN AND issuetype = Bug AND status = Done AND status changed TO Done DURING (2023-11-10, 2023-11-22)

Ste

[Marcus_palm]

Hi, this worked great! Thank you! 

[Salzi]

Try:

project = APPEN AND issuetype = Bug AND status changed to "Done" after  2023-11-10 AND status changed to "Done" before 2023-11-22 order by created DESC