Forums

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

I have a existing filter for 5 days but want to make it 5 business days.

Jon.Stauffer
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
July 17, 2023

My current formula to show tickets with no activity for 5 days is "project = DS AND status in (Open, "In Progress", Reopened, "Suspended/Pending") AND updated <= -5d ORDER BY key DESC"

I have looked at various filters to make it 5 business days and have hit walls. Please advise on what I need to change/modify.

1 answer

0 votes
Dan Breyen
Community Champion
July 17, 2023

Hi @Jon.Stauffer welcome to the community!  Here's a community article about a similar question: JQL-for-tickets-without-comment-in-5-business-days 

Hope that helps.

Jon.Stauffer
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
July 17, 2023

I'll check it out thank you!

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events