I am trying to write a JQL code for a filter that will show what's due in a specific review for every upcoming Tuesday and a separate one for the upcoming Friday. Here are some examples of what works:
"Review[Date]" = endOfWeek("-1d") /
"Review[Date]" >= startOfWeek("-1d") AND "CR1 Date[Date]" < endOfWeek("-3d")
My issue is that the function only works about half of the days, so I end up with multiple versions depending on the day viewed.
Any advice to get cleaner more consistent results? Thanks
Hi @Aimee Heigold,
What is the problem you are trying to solve here? It looks as if you are trying to fetch a list of items to discuss in a review meeting, but with a hard dependency on a date field.
Starting from that idea, your examples are pretty much ok. But have you considered solving your process differently? If you need to review stuff, why don't you use a workflow status to identify the issues that need review? Or a custom field / label / ... to identify the issues that need to be reviewed
I am aware that I don't know your full use case here, but just suggesting that there may be easier, more flexible ways to solve your problem than filtering out issues with a dynamic date on a certain day of the week.
Hope this helps!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.