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.
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)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thank you!
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.