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; } } }

JQL query for getting only working days but not include non working days in JIRA 4.3

Kalyan Kumar Das

I want jql query for SLA alert in which it starts counts only working days at the time of raise the ticket. When i created the filter it count working days and non working days. That i don't want.

Our time is:

9 am to 6 pm from Monday to Friday

Please suggest us.

Accepted answers

All comments

Shannon S

Hi Kalyan,

Jira 4.3 would be far too old to accomplish this task as the oldest version of Jira that is supported is 7.2:

Atlassian Support End of Life Policy

In more recent versions a feature is out that will stop the SLA clock on non-working days.

For your issue, you're asking for a JQL query that will help with that. Can you help explain to me how you would like this to work exactly? What kinds of things would you want it to do for you?

Shannon

Kalyan Kumar Das

@Shannon S

We are setting the value for SLA like 9,18,24 and 48 and our working days is 9 am to 6 pm from Monday to Friday. The SLA counting will be start from the created date and time of ticket. If the ticket is created on non working days then the ticket will be automatically closed and create a duplicate ticket when the working days will start. The main issue is that I need to give alerts to the reporter on working days like 18 hour left for SLA breach or 9 hours left for SLA breach etc.

I had already created the filter that counts non working hours. That is complicated to fix the alert issue. So please suggest us how SLA alert in which it starts counts only working day.

Shannon S

Kaylan,

For this you would need some kind of add-on such as ScriptrRunner for Jira. However, keep in mind that this and many other add-ons only support versions of Jira that haven't yet reached End of Life. For example, ScriptRunner only supports Jira 7.2.0 through 7.10.2.

My recommendation would be to upgrade your instance so that you're on a supported version. This way you can either use our new feature that doesn't count SLA on non-working days, or at least so that you can use ScriptRunner or another Marketplace add-on.

Regards,

Shannon

Kalyan Kumar Das

@Shannon S

Is there any other way to fix the issue. Please suggest us. We are having Script Runner in JIRA 4.3.

Welcome!

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

Quick Links

Find more posts tagged with

atlassian-marketplace

jira

jira-service-desk