nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Sujata_o8ty24

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

Accepted answers

Ravi Sagar _Sparxsys_

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

All comments

Ravi Sagar _Sparxsys_

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

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.

Screen Shot 2021-01-18 at 22.43.07.png

Screen Shot 2021-01-18 at 22.50.35.png

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_o8ty24

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

Sujata_o8ty24

Thank you Ravi!

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira-service-desk

jira-core

jira-core-server