JQL query to get all ticket except resolved ticket before a date

[Julien Nivet]

Hi, 

I would like to build a query. List all tickets (whatever the status) and removing tickets before a specific date. 

I've tried this :

project = XYZ AND NOT (resolved <= 2020-12-31)

But it is also filtering all the issue not resolved. I would like to get everything except those resolved before 2020-12-31

Many thanks for your help, 

[Dirk Ronsmans · Accepted solution]

i'm thinking something along the lines of

project =XYZ AND ( resolutiondate <= 2020-12-31 OR resolutiondate IS EMPTY)

This will give you all tickets unless those resolve before that date. if they are not yet resolved or before that date they will be filtered out

[Julien Nivet]

Thanks Dirk, It's not working as expected. I was not enough specific.

What I would like to achieve is to get : 

• Tickets not already closed 
• Tickets already resolved but after 2020-12-31

And remove those tickets: 

• Tickets already resolved before 2020-12-31

[Dirk Ronsmans]

Hmm the query itself should work but I think you want the date the other way arround

project =XYZ AND ( resolutiondate >= 2020-12-31 OR resolutiondate IS EMPTY)

So this gives the tickets that are not yet resolved (resolutiondate is empty)

OR resolved after 31/12/2020 (resolutiondate >= 2020-12-31)

Oh and if you want to remove the Closed ones with status Closed, you can of course do "AND Status != "Closed" but that depends how you define Closed :)

[Julien Nivet]

Many thanks ,it worked