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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
and add something like this as well...
AND Resolution is Empty
otherwise you will see all old closed issues
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.