How to create a jira automation to update start/due date on blocked issues?

Jespir Ragbotra

We have a project where one task issue blocks other issues. If the start date is changed, then all blocked issues should change as well. Same goes for start date. 

 

When the date changes, we'd like to have the blocked issues update by the same number of days as the one blocking it. However, I'd also like the automation to not touch any blocked issues with blank values.

 

For example: 

• Start Date for Task 1 is 2/13/23 and it's blocking Task 2 with a start of 2/17/23. If the start date of Task 1  moves to 2/15/23 (2 days later), then Task 2 will move to 2/19/23 (also 2 days later)
• Same for the End Date

 

I'm trying to get the smart values to work but am unfamiliar with those and have hard time know what can get me the results I want above. 

Here's what I have so far:

But I'm not sure about the smart values and I'm also not sure if I should have the Start and Due Dates in one automation or separate them out. Can anyone help? 

Trudy P Claspill

Hello @Jespir Ragbotra 

You can find information about smart values in the Automation documentation here:

https://support.atlassian.com/cloud-automation/docs/smart-values-in-jira-automation/

 

If Task A is blocked by Task B, does the Start Date of Task B have any bearing on when Task A can be started? It seems like really only a change to the Due Date of Task B is relevant to the start of Task A.

To accomplish what you want you will need to reference the functions that you can use to manipulate dates and times:

https://support.atlassian.com/cloud-automation/docs/jira-smart-values-date-and-time/#--

 

One thing that you will have to do is figure out how many days difference there is between the original date and the new date. When you use the Field Value Changed trigger you can reference the original value of the changed field with 

{{fieldChange.from.toDate}}

and the new date you specified with

{{fieldChange.to.toDate}}

You need the toDate function to convert the values stored in the change history from text to Dates.

To find the number of days difference between those you can use the diff function:

{{fieldChange.from.toDate.diff(fieldChange.to.toDate).days}}

If you assign that to a variable dateDiff (using the Create Variable action) then you can use that number to update the value of other date fields with the plusDays function. For example if you want to update the Due date field:

{{issue.duedate.plusDays(dateDiff)}}

 

If you don't want to update issues that have blank dates, then add Conditions to check that the date fields are not Empty.

 

Let us know if you need more guidance.