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
The Atlassian Community can help you and your team get more value out of Atlassian products and practices.
Right now I have a JQL filter that is written like this:
project = "Project Name" and status was in ("Status 1", "Status 2") during (startofday(-1d), endofday(-1d))
Every morning I am using the number from this filter to enter into a spreadsheet to log data for historical information we use.
Tues-Fri this filter works fine. The problem is on Monday I have to go into the filter and manually update the numbers to -3d to ignore Sunday and Saturday. Or, copy the filter and updated those numbers so now there are now 2 filters instead of one, just slightly different. This becomes particularly cumbersome if you have multiple filters looking for these same date ranges for various different things.
I am just wondering if anyone knows of a way to accomplish this same Filter but have it skip the Sunday and Saturday days so that if I were to look at it on Monday it would show me last Fridays results and if I were to look at tomorrow on Tuesday it would show me yesterdays (Monday) results all just using a single filter?
This is how I tackled the recording of status changes in Jira based on "business days" https://community.atlassian.com/t5/Jira-Cloud-Admins-articles/Status-Changes-in-Jira/ba-p/1806392
With Jira standard, you would be wise to do this per project (rather than Global) as chances are it will send you past the global executions on standard. It is simple as to copy and reconfigure for each project (required).
If this doesn't sort your exact use case, take some inspiration to get Jira/automation to do this task for you.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.