Forums

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

Find issues with no time logged past 2 days excluding weekends

SKAdmin
Contributor
July 24, 2023

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

1 answer

0 votes
Himanshi
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
July 25, 2023

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

SKAdmin
Contributor
July 25, 2023

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. 

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
SERVER
TAGS
AUG Leaders

Atlassian Community Events