Hello,
I would like to change the color of my jira cards based on the number of days the status has not changed. So if it does not change for 2 days then yellow and 3+ days red. I have the JQL below which gets me what I want, but It does not account for the weekends which cases lots of problems. Is there a way to exclude the weekends?
project = INDEVOPS AND status in (Blocked, "In Progress", "In QA") AND resolution = Unresolved AND NOT status changed DURING (startOfDay(-3d),endOfDay())
project = INDEVOPS AND status in (Blocked, "In Progress", "In QA") AND resolution = Unresolved AND NOT status changed DURING (startOfDay(-2d),endOfDay())
Hi @Phillip Krall and welcome to the community,
Kindly look at this thread https://community.atlassian.com/t5/Jira-questions/Exclude-weekends-in-JQL-Query/qaq-p/1030290
There isn't an actual JQL for the business days, but the above thread has a good workaround.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.