Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

Jira filter for Business days


I'm trying to create a filter to return yesterday's tickets and I used this and it works: resolutiondate >= startOfDay() AND resolutiondate <= startOfDay(1) 

The problem comes on Monday, the filter returns Sunday's tickets (zero) when I really need Friday's tickets. Suggestions?

1 answer

1 accepted

1 vote
Answer accepted

Hello Dan,

The query you mentioned is returning, in fact, all the tickers resolved between the start of the current day and the start of the next day, but not yesterday.

I'm not sure if you are resolving your tickets in the next business day and that's why you are using that query, but I think the best option to return the information you want would be to create a different filter which would apply the difference of days between Friday and Monday. Explaining better:

Let's suppose you would like to return on Monday all the resolved tickets for last Friday. You could use the following query:

resolutiondate >= startOfDay(-3) AND resolutiondate <= startOfDay(-2) 

The filter above will return all the issues resolved during the third-day counted regressively to your current date. If today it's Monday, it will count the tickets resolved on Friday.

Let me know if this information helps.

Thanks, while that works as a separate filter, I found a different solution...Subscriptions!

I have the filter run nightly generating an email with the previous days tickets. Saturday will generate Friday's tickets while Sunday and Monday will be empty since nothing was closed on their previous days. Monday morning rolls around and I can read Saturday's email about Friday's tickets.

Like Kevin Davies likes this

I'm glad to know you were able to find a better solution, Dan!

Have a nice weekend and please don't hesitate to contact us again every time you need. :)

Like Kevin Davies likes this

@Bronx Can you Post Screenshots of that Solution? Thanks

Suggest an answer

Log in or Sign up to answer
AUG Leaders

Atlassian Community Events