Exclude weekends in jql query

Question

I have a user that wants a filter to manage the SLA for their dept. But they want to exclude weekends. This is what we came up with, any ideas how to exclude weekends now?

project = INC AND status = Open AND Delegation = "CPE Incident" AND created <= -24h OR status = Assigned AND Delegation = "CPE Incident" AND created <= -48h OR status = "In Progress" AND Delegation = "CPE Incident" AND created <= -48h

Sujata_o8ty24 · Answer

Hi Phill, I have another scenario wherein I need to check if an issue is beyond the SLA, here again, i need to exclude the saturday and sunday based on the creation date. For example, if the priority of an issue is Critical, we need to resolve this within 1 day. If it has passed one day and the issue is still open then we tag them.

Currently, I have this query...created <= endOfDay(-2d) AND priority = Critical. This works great but it doesnt take into account the weekends. So if the defect was created on a friday it starts tagging on a saturday if it is still open but I want it to tag on Monday by excluding saturday and sunday.

Is there anyway I can do this with your above resolution in addition to my query

created <= endOfDay(-2d) AND priority = Critical

Phill Fox · Answer

Hi @Franzi Joseph

I am glad to have helped you. Using the startOfWeek and endOfWeek functions can be tricky to get your head round at first but they are super powerful along with the ones for Day/Month.

kind regards

Phill

Franzi Joseph · Answer

Hey @Phill Fox ,

great idea to share your knowledge even 5 years later :DDD.

I was just looking for exactly that filter, not with created but with updated, but it works the same way :) .

Thanks a lot and BR

Franzi