Start and end date automation via Status of the issue

Question

Hello,

we wanted to implement an automation that changes the end date of the issue to todays date, when it has exceed the original estimate. How will the JQL Query look like for this case ?

Furthermore we want to have the automation that when ever an issue gets transitioned to "in Progress", then the start date should be {{now}} and the end date should be {{now}} + original estimate, how this phrase should look like in the automation config?

Thanks in advance.

Tharaka_Hettiarachchi · Answer

Hi @Gentrit Cerimi ,

First Scenario

For the first scenario, you can create a automation script as follows

1. Create 'Advanced Compare Condition'  to check the original estimate greater than total time spent

2. Then add a 'New Action' -> Edit Issue

Update due date field to {{now}}

Cheers!

Bill Sheboy · Answer

Hi @Gentrit Cerimi

You note that you want to implement an automation rule to solve this need.  What have you tried thus far to accomplish this?

Please consider posting images of your current rule, details from the audit log, and describe what is not working.

Kind regards,
Bill

Gokaraju gopi · Answer

Hi @Gentrit Cerimi

Hope following should help you for automation config

Variable name: TimeTrakingInDays

Smart value: {{#=}}{{issue.timetracking.originalEstimateSeconds}} / (60 * 60 * 8){{/}}

Start date: {{now}}

End date: {{now.plusBusinessDays(TimeTrakingInDays.asNumber)}}