Filter our weekends

Question

I've tried to find some answers here, but can't seem to locate something that works, so I thought I'd ask.

Trying to pull tickets in a report that haven't been updated in the past 3 days, but excludes weekends. How can I update the below to exclude weekends?

project in (EXAMPLEPROJECTNAME) AND resolution = unresolved AND updated <= -3d AND assignee in membersOf("Creative Services") AND status not in (EXAMPLESTATUSES) ORDER BY project

Dan Breyen · Accepted Answer

I haven't played with it very long, but I think you could use the diff function for dates and then use the businessDays units.  I think you're looking for haven't been updated in the last 3 BUSINESS days, so this might work.

Check out this page.

Jira smart values - date and time | Cloud automation Cloud | Atlassian Support

That's for automation, but I would guess the functions still apply. (I couldn't find the other page)

Nolan McConnell · Accepted Answer

I use the following JQL to see all issues that haven't moved in the last 5 days and excluding weekends:

(updated < -5d AND updated > startofWeek(-1d)) OR (updated < -5d and updated < startofweek(-1d)) AND status not in ("To Do")

I use this one for last day exluding weekends:

(status CHANGED DURING ("-1d", now()) AND status CHANGED AFTER startOfWeek()) AND status not in ("To Do")

You should be able to edit one of the two I've shared and put 3 in there for the timeframe.