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; } } }

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

Mike_schoo8

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.

Accepted answers

Mikael Sandberg

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

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.

All comments

Mikael Sandberg

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

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_schoo8

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: 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_schoo8

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira-service-desk-cloud

jql

automation

jira-service-management-cloud

jira-service-management