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

Gaetan Gaston January 7, 2021

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

3 answers

1 accepted

0 votes
Answer accepted
Gaetan Gaston January 7, 2021

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))

0 votes
Sandesh Shetty
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
January 7, 2021

@Gaetan Gaston 

You can just run this,

duedate  < 183d  AND "Start date" < 213d

kindly accept the answer if this resolve the issue

0 votes
Jack Brickey
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
January 7, 2021

Something like this...

”start date” <startofday(“+180”)

Suggest an answer

Log in or Sign up to answer