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)

[Mark Segall · Accepted solution]

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.

[Vasilis Gen]

Thanks @Mark Segall 

[Mohamed Benziane]

Did you try my answer below ?

[Mohamed Benziane]

Hi,

You can try this

NOT status changed TO "Done"

I will go for "startOfMonth(-x)" and "endOfMonth(-x)" instead of the  hardcoded date

x mean the number of month you want to go back