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?

[Scott Wagner · Accepted solution]

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.

[Mehmet Kazgan]

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.

[Mehmet Kazgan]

(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.

[Boris Georgiev _Appfire_]

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