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; } } }

JQL for issues that the status was not change to Done during a certain period

Vasilis Gen

Hi all,

Trying to create a query that will return the issues that were updated during January and they didn't get the status Done during January.

The bold one is the problematic sections of my query. Any Ideas?

project = CPD AND issuetype in (Story, Bug, Task, "Tech Task") AND updated >= 2023-01-01 AND updated <= 2023-01-31 AND status was not changed to Done during (2023-01-01, 2023-01-31)

Accepted answers

Mark Segall

Hi @Vasilis Gen - I think you want to tweak it like this:

project = CPD AND issuetype in (Story, Bug, Task, "Tech Task") AND updated >= 2023-01-01 AND updated <= 2023-01-31 AND status WAS NOT Done during (2023-01-01, 2023-01-31)

Essentially there is no "was not Changed". You would simply state that issue was not Done during that timeframe.

All comments

Mark Segall

Hi @Vasilis Gen - I think you want to tweak it like this:

project = CPD AND issuetype in (Story, Bug, Task, "Tech Task") AND updated >= 2023-01-01 AND updated <= 2023-01-31 AND status WAS NOT Done during (2023-01-01, 2023-01-31)