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 to search for a specified time in a custom field and run 30 minutes prior.

Nolan Stone

Hello,

Our company utilizes JSM for offboarding tickets. I have two separate custom fields on the offboarding ticket to capture the date and time that the offboarding needs to be completed. I am wanting to create an automation to send out a reminder notification to the assigned agent 30 minutes before the selected time on the offboarding tickets. Any guidance on a JQL Query I can utilize to accomplish this?

Here is what I have been able to put together so far with no luck. Screenshot 2024-08-22 165636.png

Accepted answers

Mikael Sandberg

Hi @Nolan Stone,

Welcome to Atlassian Community!

The out-of-the-box JQL cannot do date compare (that is basically what you are looking for) so you would have to use one of the apps on the Marketplace in order to do this.

Another option would be to use SLAs and specific statuses when the SLA starts and stops.

All comments

Mikael Sandberg

Hi @Nolan Stone,

Welcome to Atlassian Community!

The out-of-the-box JQL cannot do date compare (that is basically what you are looking for) so you would have to use one of the apps on the Marketplace in order to do this.

Another option would be to use SLAs and specific statuses when the SLA starts and stops.

Nolan Stone

Hi @Mikael Sandberg,

Thanks for the quick reply!

Is there a specific app on the marketplace that you suggest for this?

Mikael Sandberg

I have used JQL Tricks and Enhanced Search (Scriptrunner) in the past. I am pretty sure Enhanced Search has a date compare and it looks like JQL Search Extensions does too.

Nolan Stone

Got it. I will take a look at those. I appreciate the feedback!

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