Forums

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

I need to write a JQL for fetching issues not updated for 3 days and these days should exclude weeke

Priyanka
Contributor
September 23, 2019

Hello,

 

I need to write a JQL for fetching issues not updated for 3 days and these days should exclude weekends. 

2 answers

1 vote
fran garcia gomera
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 23, 2019
0 votes
Manisha Kharga _Appfire_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 23, 2019

Hi  @Priyanka ,

Please use the below JQL, it will result in the issues not updated from 3 days.

project ="Sample" AND updated <= startOfDay(-3)

 

Thanks,
Manisha

fran garcia gomera
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 23, 2019

I think @Priyanka trouble was with the weekend days, yoou need to get 5 days if today is tuesday(monday, sunday, saturday, friday and thursday) and get 6 days if today is monday and 4 days if today is wednesday.

Jack Brickey
Community Champion
September 23, 2019

and add something like this as well...

AND Resolution is Empty

otherwise you will see all old closed issues

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events