Find issues with no time logged past 2 days excluding weekends

Question

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()

Shelli Kleman · Answer

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.

Himanshi_me2dvl · Answer

Hello @Shelli Kleman ,

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