Looking for some help on the correct JQL for colouring cards based on due dates within issues.
I have tried to write a JQL to colour a card amber if due date of task is within 3 days, I have additionally tried to write a JQL to colour a card red if the due date is today or over due.
This hasn't worked and a date which is now in the past is still showing as amber rather than red.
Can anyone tell me how I should write my JQL to remedy this.
Did you try this way?
Hi @Gary Welcome to the community!
duedate >= "0" AND due <=3d for the issues due in the next 3 days and not overdue
duedate <= "0" for issues now overdue
Hope that helps!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Welcome @Gary
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Gary
Welcome to community!
I suppose the problem here is the sequence
> now is also >-2d :)
Reorder them with the now() first and then -2d and let me know whether that helped
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.