Hello,
I need to write a JQL for fetching issues not updated for 3 days and these days should exclude weekends.
Check here https://community.atlassian.com/t5/Jira-questions/How-to-query-for-specific-days-of-the-week-in-a-given-month/qaq-p/858269. it's a very interesting approach
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
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.
and add something like this as well...
AND Resolution is Empty
otherwise you will see all old closed issues
It looks like you're new here. Sign in or register to get started.