nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Jira filter for Business days

Bronx

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?

Accepted answers

Petter Gonçalves

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.

All comments

Petter Gonçalves

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.

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.

Bronx

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.

Petter Gonçalves

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.

Tony B_m5wflb

@Bronx Can you Post Screenshots of that Solution? Thanks

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira