How can I exclude the weekends to tag an issue for SLA

[Sujata]

I have a scenario wherein I need to check if an issue is beyond the SLA, I need to exclude 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 in addition to my below query? 

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

[Ravi Sagar _Sparxsys_ · Accepted solution]

Hi @Sujata 

That's why we have calendars where you can define your working days, hours and holidays for your SLA goals.

Take a look at this page.

I hope it helps.

Ravi

[Sujata]

Thank you Ravi!

[Gökçe Gürsel {Appfire}]

Hi @Sujata ,

If you're using a Software project or Business project, you can try Time to SLA.

You can define a calendar that excludes weekends and TTS clock will pause during weekends. 

You can also define a TTS notifier to fire an event that can be processed by third party plugins so that you can tag your issues.

Time to SLA works with Jira Software , Core and Service Management.

Please let me know if you have further questions.

Cheers,

Gökçe

Please note that I'm one of the members of the Snapbytes team.

[Sujata]

Thank you Gokce! So there is no way to check this with the JQL query? We dont have any plugins, thought we could do this via JQL query. I am surprised simple functionality like this is a plugin.

[Gökçe Gürsel {Appfire}]

If you're using JSM, you can just configure a calendar for your SLA that excludes weekends. That is the most sensible way to manage this requirement imo. 

https://confluence.atlassian.com/servicemanagementserver/create-and-edit-sla-calendars-976770869.html

If you're using or want to use Software or Core, I suggest TTS. 

Cheers,

Gökçe