nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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!

Accepted answers

Ste Wright

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

All comments

Ste Wright

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

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

Marcus_palm

Hi, this worked great! Thank you!

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud