Jira quick filter to see issues updated during the last working day

leodavesne March 25, 2024

Hi there!

I am trying to set up a quick filter in Jira to easily see issues updated during the last working day. So the day before if it's a Tuesday, Wednesday, Thursday and Friday, or on Friday when it is a Monday.

My intention is to check issues that were updated the day before, to ask if my teammates need to share specific updates about those.

 

For now I have this:

> (updatedDate >= -1d AND updated > startofWeek() ) OR (updatedDate >= -3d AND updated < startOfWeek())

But this only catches issues that were updated before the current time of the day after. For example, an issue updated at 9 am on Friday wouldn't be selected if I select this quick filter on Monday at 09:01 am.

 

How would you set up such a filter so that it would catch all issues updated at any time of the day the working day before?

Any help is welcome 🙏

1 answer

1 accepted

2 votes
Answer accepted
Matt Parks
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 25, 2024

You can changed updatedDate > = -1d to updatedDate >= startOfDay(-1) (and the -3d accordingly)

That will return anything that was updated since the beginning of yesterday. If you don't want to include anything that was updated today, you would need to include the following clause:

AND updatedDate <= startOfDay()

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
AUG Leaders

Atlassian Community Events