Quick Filter Query - Hide issue that are in the future (more thn 6 Month)

Gaetan Gaston

Hi folks,

I'm have a team that has repetitive task and in order to plan, we will create issue from now to end of 2022 (it is controle and process check). Therefore in our Jira, we want to implement a code that said : Exclude issue that are in the future (more than 6 month)

MY WISH: I want to :

-> Exclude issue that START DATE is more than 26 weeks or 182 days

-> Exclude issue that DUE DATE is more than 26+4 weeks or 212 days

 

CODE FAIL

NOT ("Start Date" < 183d OR duedate < 213d)

 

What would be the rignt code ?

Thanks

Gaetan Gaston

It is always complicated with negative query (like "Exclude"), even more if it is crossed by another multiple-date query (older than "Start-date" and older than "Due-Date") 

Here is the best I have found :

("Start Date" = empty AND duedate = empty) OR ("Start Date" = empty AND (duedate < 213d)) OR (("Start Date" < 183d) OR duedate = empty) OR (("Start Date" < 183d) AND (duedate < 213d))