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

Set "End Date" based on "Start Date" + Original Estimate

Casper Frost_xq4n9i

Hi,

I am trying to update the "End Date" of an issue using Jira Automation.

What I want is to use the fact that all my issues have a start date, and when I estimate a given issue and provide an "Original Estimate", I then want to extract the value in that field, add the relevant number of days and set the "End Date" of the issue based on this.

As I am using a plugin (BigGantt) my Start and End dates are in a separate custom field, which I have confirmed are "Date" fields (unsing the /editmeta service).

I have verified that this function gives me the information I want, in this case "1", for 1 day:

issue.timetracking.originalEstimate.remove("d")

I have also verified that I can set the date field of the end date using this function:

"customfield_10034" : "{{issue.customfield_10015.plusDays(1).jiraDate}}}"

Now I simply replace the 1 with my second statement, with the function from my first statement. However, this doesn't work, I get an invalid JSON error.

{
"fields": { 
"customfield_10034" : "{{issue.customfield_10015.plusDays(issue.timetracking.originalEstimate.remove("d")).jiraDate}}}"
}
}

My best guess is that this is a type conversion issue, as the 1 in the first statement is a string, and the input required for the second statement is an int.

I have not been able to find parseInt (or similar) function.

Any ideas what's going on here, or how to achieve the initial objective?

Accepted answers

Bill Sheboy

Hi @Casper Frost -- Welcome to the Atlassian community!

I have not found a way to nest smart values, using one as part of another function in the automation. I think there is an open backlog item for Code Barrel (now part of Atlassian) to add the feature.

Best regards,

Bill

All comments

Bill Sheboy

Hi @Casper Frost -- Welcome to the Atlassian community!

I have not found a way to nest smart values, using one as part of another function in the automation. I think there is an open backlog item for Code Barrel (now part of Atlassian) to add the feature.

Best regards,

Bill

Casper Frost_xq4n9i

Thanks Bill, thanks for the quick response!
Happy to hear it's not my coding skills that are the cause - but of course sad that it's not (yet) possible.

Mateusz Sołowianiuk_f8cfkk

Hi Casper,

Generally speaking, answers to your questions are present in wiki pages linked below:
* third info section in Quick start with BigPicture;
* details referring to Start / End date fields in Technical configuration - General - Task configuration.

To make the long story short, BigPicture will automatically calculate End Date based on the Start Date and Original Estimate provided. If, on the other hand, no Original Estimate is provided, the task's duration will be set to 1 day. Please note that this applies only to the newly created tasks - if it is desired to be applied to the existing tasks you will need to map End Date to Original Estimate in task configuration section.

Also, if you decide to use custom Jira fields other than default Start/End Date, it is possible to do so and migrate the data to the newly chosen fields. Please refer to the second bullet point listed above and remember that the results of migrating the dates are irreversible - the documentation on this will provide more information.

I hope that this answers your doubts. However, in case of any further questions, please do not hesitate to e-mail us at support@softwareplant.com.

Best regards,
Mateusz Sołowianiuk - SoftwarePlant Support

Ansar Rezaei

Hi @Mateusz Sołowianiuk

I have the same issue. I'm familiar with this configuration that you mentioned. But the problem is that you don't have an End date in any other issue view If you set the end date to Original Estimate. It just is shown in Bigpicture program and not stored anywhere.

@Casper Frost I have the exact issue that you mentioned. Do you found any solution to it?

Casper Frost_xq4n9i

Hi @Ansar Rezaei , unfortunately I didn't.
To be honest, after the message from @Bill Sheboy I stopped trying to make it work. Hadn't seen the @Mateusz Sołowianiuk's response until now - I'll try that out once I get some more time.

Thanks all.

Ansar Rezaei

Thank you so much.
@Casper Frost I also ask it here and I want to solve it this way, https://community.atlassian.com/t5/Jira-Questions/Update-End-Date-by-Start-Date-and-original-Estimate/qaq-p/1415498

Could you help me with that?

Welcome!

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

Quick Links

Find more posts tagged with

cloud

jira-software