Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Way for JQL to find Issues in a particular Status for the previous day excluding weekends?

Hi,

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?

Thanks,

1 answer

0 votes
Curt Holley Community Leader Dec 12, 2021

Hi @Matt Steadman 

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.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Site Admin
TAGS
Community showcase
Published in Jira Work Management

Lessons from Vilius Zigmantas’ path to Continuous Process Improvement at GeoComply

  “Organizations are made of people who create and follow processes which are constantly changing and are in need to be supported and nurtured… this is the spot where I realized I can br...

1,601 views 9 18
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you