Change card color based on days not counting the weekend

Phillip Krall

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

Alex Koxaras -Relational-

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.