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

Difficulty Setting Epic Start Date to Earliest Child Date with Jira Automation

Colter Sherley

Hello all,

I have been following an answer (first answer) to a post provided by @Trudy P Claspill but I am having issues with the last steps.

I am nearly there in getting it to work in my environment. The only problem is I am on the Jira Data Center version and the field "Start Date" is not available as an option in the edit issue dropdown. It appears the workaround for this is to write it in JSON. So I have written the last step to Trudy's answer as follows under edit issue->additional fields:

{
"fields": {
"Target start": "{{lookupIssues.first.Target start}}"
}
}

Unfortunately when the rule is run, it errors out with an error that reads:

ABC-553 (Unparseable date: "" (customfield_11000))

Investigating a little further I did an export to CSV with the Target start field in the list of columns and the format looks like this "Nov/14/23 7:00 PM".

In the epic field on the Target start field it says:

"The targeted start date. This custom field is created and required by Portfolio for Jira.

- Use the d/MMM/yy date format"

Does anyone know how I can fix this issue?

Accepted answers

Bill Sheboy

Hi @Colter Sherley -- Welcome to the Atlassian Community!

Have you tried using the format() function to set the date to the format you noted?

https://confluence.atlassian.com/automation/jira-smart-values-date-and-time-993924864.html

Kind regards,
Bill

All comments

Bill Sheboy

Hi @Colter Sherley -- Welcome to the Atlassian Community!

Have you tried using the format() function to set the date to the format you noted?

https://confluence.atlassian.com/automation/jira-smart-values-date-and-time-993924864.html

Kind regards,
Bill

Colter Sherley

Thanks for the reply, @Bill Sheboy . I did, I should have mentioned that in the post. This is how I did it. Did I setup the smart value correctly?

Bill Sheboy

Thanks for that information, and FYI that I am using Jira Cloud and not Server, and so there could be at least three causes of what you see:

Most likely one is the field is not in the Lookup Issues result: https://jira.atlassian.com/browse/JIRAAUTOSERVER-877

When Lookup Issues was added for Jira Cloud, it only had about a dozen fields. About a year later they added all of the other fields. To check if the Target start is in the lookup, please use the log action to write this to the audit log after the lookup:

Target start: {{lookupIssues.first.Target start}}

If it is blank, the field is not supported yet. A work-around can be to call the REST API function for an issue search with JQL and the Send Web Request action. The web response can then be used in the same way as {{lookupIssues}}

Next, if the field is present, I do not know the format / field type of Target start with Jira Server. Some of the Jira fields indicate "date picker" in the admin functions, but they are available to rules as text. In that case, try first converting to a date, then adding the format:

The final possibility is if the nested double quotation marks are causing the problem: one for the JSON and one for the format() function. To solve that, a created variable could be used to first format the date.

Colter Sherley

@Bill Sheboy I think you figured it out. I created a log action with exactly what you wrote and here is the result. Blank! So that would be why I am seeing the "unparseable date" error.

I have never used the REST API so I am not sure where to begin on that.

I already have target start and end dates populated at the story level. Is there another easy way to transfer these child dates up to the epic level not using lookup issues?

Welcome!

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

Quick Links

Find more posts tagged with

server

jira

jira-software-server

automation