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; } } }

How to remove the impact of non-working days on filter subscriptions.

Scott Wagner

I have an issue filter (project = MF3 AND issuetype = Bug AND status = "In Progress" AND updated <= -36h ORDER BY updated ASC) with a subscription to email results each workday.

Monday and Tuesday results are artificially inflated as no one works weekends. Short of creating a separate filter and subscription for Monday, with another for Tuesday, how do I exclude non-working days?

Accepted answers

Scott Wagner

Thank you both for your suggestions. I’ve tested both and unfortunately neither provides the results I am seeking. At this point I’m just going to create separate filters and subscriptions to address Monday and Tuesday results.

All comments

Boris Georgiev [Appfire]

What about adding updated >= startOfWeek(1d) to the query - this should filter all results after Monday 00:00

Mehmet Kazgan_qriny9

(project = MF3 AND issuetype = Bug AND status = "In Progress" AND updated > startOfDay(-0d) ORDER BY updated ASC)

This should give you all issues updates today. If (-0d) changed (-1d), would get the issues yesterday and today.

Scott Wagner

Mehmet Kazgan_qriny9

Sure. Why do you run the subscription daily for the weekends? There is an option that you can save the subscription for the weekdays, excluding weekends.