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

Filter for Off-hours Number of Created Tickets

Bar Abergel

Hey guys,

I'm using the native SLA for Jira Service desk with a dedicated calendar i've created for the team's working hours.

I want to have a filter for tickets who has been opened not during the working hours, outside of the mentioned calendar/when the SLA has not started.

Please advise, thanks!

Accepted answers

Walter Buggenhout

Hi @Bar Abergel,

As you have noticed, filtering dynamically based on dynamic time ranges is not a walk in the park. You can make your querying a lot easier if you add a custom field to indicate if an issue was created within or outside SLA working hours. Using automation, you can then simply set the proper value in that field and make it very simple to query for issues by that custom field.

I created a quick sample rule using the labels field, as you can see here:

Screenshot 2022-12-27 at 14.20.45.png The conditions in the rule use smart values. To build rules using date and time values, you may find this support article a very useful resource.

Hope this helps!

All comments

Bar Abergel

meliodas16

Hello @Bar Abergel ,

Please have a look at this thread and see if it may help you : https://community.atlassian.com/t5/Jira-questions/Find-all-issues-created-outside-of-normal-working-hours/qaq-p/1978132

Kind regards.

Bar Abergel

Hey! thank you for your answer.

I took a look on these answers but non of them works for me.

I need to see the tickets that has been created from 19:00 till 07:00 and on non working days (Saturday) according to the SLA calendar..

Walter Buggenhout

Hi @Bar Abergel,

I created a quick sample rule using the labels field, as you can see here:

Screenshot 2022-12-27 at 14.20.45.png The conditions in the rule use smart values. To build rules using date and time values, you may find this support article a very useful resource.

Hope this helps!

Bar Abergel

Thank you so much, this is a great solution for the non-working days!

Any suggestion on how to add labels to tickets who were created outside of the working hours as well?

Walter Buggenhout

Hi @Bar Abergel,

Yes, the following automation rule could do the trick:

Screenshot 2023-01-04 at 10.29.35.png

The rule is triggered when an issue is created. An SLA has different states (running(), paused() or completed()). That's what I used in the condition at the second step: if the issue is created outside the calendar hours, the SLA state will be paused(). In that case you can add a label to indicate this to your issue.

Bar Abergel

Thanks again Walter, this is a great solution!

The JQL isn't working for me when I'm trying to validate it.

status not in (Pending, "Waiting For Customer") = paused()

How exactly should I use the paused() function in this case?

Welcome!

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

Quick Links

Find more posts tagged with

cloud

jira-service-management-cloud

jira-service-management