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

Need a JQL automation to send reminders when the Planned Start (custom field) time is past.

Mike March 30, 2022

For our Change Management project, we use 2 customer fields, Planned Start and Planned End rather than a "due date". What I am trying to do is send out a reminder using automation when that Planned Start is reached and the status hasn't been advanced. An issue will be sitting at status Awaiting Implementation. When the change is started, the status should be changed to Implementing by the change owner (Assignee) manually. I'm new to Jira as a whole, but I have made a number of automation rules. I couldn't figure out how to do this with the non-JQL options.

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.
March 30, 2022

I would use the status in the scheduled query and then do a compare between the two dates, like this:

{{now.isAfter(issue.Planned Start)}}

It will return true if now is after your planned start and you can then add a comment to the change or send an email. 

Mike March 30, 2022

Hi Mikael,

I need a little more help, as I said I'm very new to this. I have an existing JQL query that works for another automation so I was going to use it and tack this on to the modified end but I know it is wrong.

The bit you gave me looks like smart values and I'm not sure how to work it in. Can you give additional guidance on that?

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.
March 30, 2022

No worries, so this is what the automation would look like:Screen Shot 2022-03-30 at 4.03.38 PM.png

This would run every workday at 9 am and only look at issues in the Awaiting Implementation status (the picture is missing the "" around the status, and if you want to narrow it down further you should add the issue type in there as well...).

Screen Shot 2022-03-30 at 4.03.09 PM.png

If there are issues returned by that query, do a date compare between now and your Planned Start (and yes, that is a smart value) and if it returns true, add a comment to the request. It is set up to share that comment to the customer, but you can make it internal, that way only the assignee and watchers will see it.

Mike March 31, 2022

Thanks, Mikael, with some minor tweaking I got it to work. You've been a great help!

Like Mikael Sandberg likes this

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events