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.

[Mikael Sandberg · Accepted solution]

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!