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

JSM Custom Notification

Natasha Richardson

Hi all. I am looking for assistance on a custom JSM notification I've created in Legacy Automation that is not executing due to the JQL condition not being met.

I am a bit confused because the JQL query works when I type it in the search issues and successfully pulls up the issues that meet the condition. This is the query: (created >= startOfWeek("-1d") AND created <= startOfWeek("+1d"))

The query is checking for issues created on Saturday and Sunday.

My custom alert logic is simple:

When an issue is created,

if (created >= startOfWeek("-1d") AND created <= startOfWeek("+1d"))

then send an email

Thanks in advance for the assistance

Natasha

Comments

Natasha Richardson

I removed the AND part of the query and got it to work.

Natasha Richardson

Bugger. Removing that AND clause doesn't exclude weekdays.

Kalin U

Your JQL statement in your post should work for issues created in the most recent weekend, with a slight change though:

created >= startOfWeek("-1d") AND created < startOfWeek("+1d")

>= startOfWeek("-1d") translates to on or after Saturday
< startOfWeek("+1d") means before Monday

Can you share a (redacted) screenshot of your automation rule?

What don't you expect to see in the results?

Natasha Richardson

Hi Kalin. Thanks for the response and yes, I want to capture tickets that come in over the weekend and basically send an email to the customer saying you've reached us after hours, etc.

When I removed this part 'AND created <= startOfWeek("+1d"))' the results returned tickets created on Monday. I am in Chicago so was testing this over the weekend last night. I created a ticket after Midnight and the JQL included that ticket when I removed the AND clause. Not what I want.

So the original JQL query works to filter only to Saturday and Sunday but for some reason, the Custom Notification I created didn't execute because it said conditions weren't met.

I wonder if maybe the rule is looking for the ticket to exist first and then evaluate the date? But that can't be right because it should be checked when the issue is created.

Screenshots of Custom rule attached

Screenshot 2023-08-28 at 9.15.25 AM.png

Screenshot 2023-08-28 at 9.14.52 AM.png

Natasha Richardson

My man. I think your slight change did it. Removed the = in the second part of the clause and just sent a ticket and it executed the way I wanted. I'll have to wait until the weekend though to see if it's working for Saturday and Sunday.

Screenshot 2023-08-28 at 9.30.13 AM.png

Cassie the Jira Mechanic

@Natasha Richardson I would approach this a bit differently. I would make sure I have SLA calendars in my JSM desks are set correctly to match my Agents's schedules. Then I would use SLA JQL:
withincalendarhours()
to filters issues whose SLA clock is not running according to the SLA calendar.
I hope this helps!
( More info about SLA related JQL: Using JQL queries specific to SLAs | Jira Service Management Data Center and Server 4.18 | Atlassian Documentation)

Natasha Richardson

Thanks. Yeah, there are a few different ways to do this for sure and your approach seems much simpler. I may tweak it anyway because I didn't include after-hours for during the week. I asked Chat GPT and it gave me createdDate >= startofDay("America/Chicago") AND createdDate <= endofDay("America/Chicago") AND createdDate NOT BETWEEN startofDay("America/Chicago 08:00") AND startofDay("America/Chicago 17:00"))

This translates to tickets created outside of the specified business hours (8 am-5 pm) M- F in the Central Time Zone. It uses the NOT BETWEEN clause to exclude tickets created between 8 a.m.-5 pm M-F.

I didn't know you could directly specify a timezone in the query like that so that is pretty neat as well. I do have to consider different time zones with this setup for India, London, Poland, Brussels, Chicago, and some others.

This one ChatGPT wrote taking timezones into consideration but it says to replace the timezones with the relevant ones for your business hours.

createdDate >= startofDay("+05:00") AND createdDate <= endofDay("+5:00") AND createdDate >= startofDay("-7:00") AND createdDate <=endofDay("-7:00")

Kalin U

@Natasha Richardson Please follow up with your latest observations. Also, did you check your Jira's instance time settings:

<site>.atlassian.net/jira/settings/system/general-configuration: Default user time zone
How to find the timezone of the JIRA server, in th... (atlassian.com) - see the last comment

Lewis Cook_vntdgk

Suggesting a slightly clunkier approach from how I've set stuff up on our service desk.

For context, we track the day and month issues are created as custom fields for reporting and trend purposes using the following automation rule:

Screenshot 2023-08-30 100626.png

Following on from the above it would certainly simplify the JQL for your notification rule to be :

"Day Created" in (Sat,Sun)

Natasha Richardson

Hi,

I'm not having much success with this feature. We have our calendars created and time to acknowledge and time to resolution SLAs set up. I'm using the legacy automation bc the format of the notification looks like the standard customer notification but for some reason the automation doesnt seem to be detecting the issues sla isnt running when i create a test ticket. I have today's date in as a holiday just for testing purposes and I've tried with '=' and '!='

Am I missing something here?

TI Screenshot 2023-08-30 at 1.56.43 PM.png Screenshot 2023-08-30 at 1.57.37 PM.png Screenshot 2023-08-30 at 1.58.59 PM.png

Natasha Richardson

Thanks. I'm going to try Cassie's approach because we need to include Holiday hours as well for all of our locations and we can plug in Holidays in the SLA calendars so this should be easy but it's not working for me.

Cassie the Jira Mechanic

@Natasha Richardson find me on LindedIn and shoot me a message I'll make time to help you the best I can!

Natasha Richardson

Answer accepted with one caveat, you will need to stack the re-fetch issue action to the automation otherwise, running this with the Issue Created option doesnt allow time for the SLA timer to be evaluated before the rule completes. Same goes for trying to evaluate the created date field.

This is a known issue:

https://jira.atlassian.com/browse/JSDCLOUD-8893

Post on re-fetch

https://community.atlassian.com/t5/Jira-questions/Is-there-anyway-to-add-a-quot-time-delay-quot-for-everyactions/qaq-p/1447213

https://jira.atlassian.com/browse/AUTO-238

Welcome!

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

Quick Links

Find more posts tagged with

notification

jira-cloud

jql