Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Leah Willman
June 25, 2018

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!

2 answers

0 votes
Mirek
Community Champion
June 25, 2018

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.

0 votes
Daniel Pollak
Contributor
June 25, 2018

Suggest an answer

Log in or Sign up to answer