How can I retroactively set Issue Start Date to the Earliest Work Logged Date in Jira Cloud.

[Jon Platt]

Hi. I'm trying to use automation in Jira Cloud to set the Start Date of issues (work items) to the date and time that work was first logged against the issue.

This is easy if work has never been logged because I can use Start Date = {{worklog.started}}.

How do I do this retroactively for existing issues that already have work logged? I've tried using {{#issue.worklog.sortBy("started").first.started.jiraDate}} and {{#lookupIssues.first.worklog.sortBy("started").first.started.jiraDate}} but no value is returned.

I've read that worklog lookups are not supported in automation for Jira Cloud. Any other ideas? Thanks in advance?

[Bill Sheboy · Accepted solution]

Hi @Jon Platt 

For a single work item, please try this value for the earliest started date / time in the worklogs:

{{issue.worklogs.started.min}}

As that is a date / time and Start Date field is a date only, please add the jiraDate format to the end to set the field in the correct format:

{{issue.worklogs.started.min.jiraDate}}

Kind regards,
Bill

[Jon Platt]

Excellent! That works perfectly. Thank you! Screenshot to help others with the same question:

[Trudy Claspill]

Hello @Jon Platt 

Can you please share with us images of your entire automation rule?

Can you please share the details from the Audit Log for execution of the rule?

How are you triggering the rule? How are you selecting the issues you want to update?