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

[Mike]

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.

[Mikael Sandberg · Accepted solution]

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]

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]

No worries, so this is what the automation would look like:

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...).

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]

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