Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

JQL Query to search for a specified time in a custom field and run 30 minutes prior.

Nolan Stone August 22, 2024

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

1 answer

1 accepted

3 votes
Answer accepted
Mikael Sandberg
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
August 22, 2024

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 August 22, 2024

Hi @Mikael Sandberg

 

Thanks for the quick reply!

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

Mikael Sandberg
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
August 22, 2024

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 August 22, 2024

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

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events