We are trying to keep track of In Progress issues that don't have time logged after 2 days, but the weekends keep messing up our report. Based on all the other posts this should work but it doesn't. Our start of week is Sunday. Any suggestions Atlassian community?
1st JQL worklogDate > -2d OR worklogDate > -5d AND worklogDate > startOfWeek(-2d) AND worklogDate < startOfWeek() ORDER BY updated DESC
2nd JQL (Filter != WorkLog2BusDays OR timespent is EMPTY) AND type in (task) AND status in ("In Progress") AND Sprint in OpenSprints()
Hello @SKAdmin ,
Welcome to the community!
There are some suggestion made on the community discussion similar to your use case :https://community.atlassian.com/t5/Jira-Service-Management/How-do-I-write-JQL-to-find-issues-that-have-not-been-commented/qaq-p/2284807
Please consider going through it. Hope it would help
Thank you Himanshi - I've read through all of these, that example has no info regarding excluding weekends. I honestly can't believe something some common would be so difficult to do.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Online forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.