Community Announcements have moved! To stay up to date, please join the new Community Announcements group today. Learn more
×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,
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
Thanks Dirk, It's not working as expected. I was not enough specific.
What I would like to achieve is to get :
And remove those tickets:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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 :)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.