You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
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
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.
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.
That's for automation, but I would guess the functions still apply. (I couldn't find the other page)