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

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