Define a filter for stories with no progress more than 3 days, excluding weekends

Question

I want to define a filter for stories wich weren't beeing in progress more than 3 days, excluding weekends because I don't want them to be counted.

for example:

The day I do the filter is Tuesday.

I have an issue_1 that on Tuesday (in the last week) is the last time it was updated.

I have also issue_2 that on Thursday is the last time it was updated.

---

The filter will return only issue_1.

(issue_1 - I count Wednesday, Thursday and Monday = 3  [Friday, Saturday and Sunday are not counted]

issue_2 - I count only Monday - because I don't want the weekends [Friday, Saturday and Sunday to be counted])

Thanks!

Mirek · Answer

I am afraid that i would be hard to achieve by only using OOTB JQL function. There are still open issue to exclude non working days from search reesults

https://jira.atlassian.com/browse/JRASERVER-22506

https://jira.atlassian.com/browse/JRASERVER-27539

Someone tried to use this function ..

updatedDate >= -1d OR ( updatedDate <= endOfWeek(-1w) AND updatedDate >= -3d)

but this is not 100% perfect solution which you should search for.

Daniel Pollak · Answer

I think this was answered here:

https://community.atlassian.com/t5/Jira-questions/JQL-How-to-extend-my-past-day-query-over-the-weekend/qaq-p/432313

is that what you need?

BR,
Daniel