Syncing time fields

Originally asked by Harold Oconitrillo on 16 November 2022 (original question)


Hello,

I’m trying to sync the fields in this guide between Azure Devops and Jira, but once work item is synced. The values in Jira get deleted.

https://docs.idalko.com/exalate/display/ED/How+to+synchronize+Time+tracking+on+Jira

The scripts:

AES_ONSITE.issue.originalEstimate = NEW_PORTAL.issue.“Microsoft.VSTS.Scheduling.Effort”
AES_ONSITE.issue.timeSpent = NEW_PORTAL.issue.“Microsoft.VSTS.Scheduling.CompletedWork”


Answer by Kellie Noumi on 30 November 2022

Hi Harold Oconitrillo

Do you have any update for us on this issue?

Cheers,

Kellie


Comments:

Ariel Aguilar commented on 01 December 2022

Hi Kellie,

Please try the following:

if (executionInstanceName == "AES_ONSITE") {
    if(AES_ONSITE.issue.originalEstimate) {
    NEW_PORTAL.issue."Microsoft.VSTS.Scheduling.Effort" = (AES_ONSITE.issue.originalEstimate as Double)/3600
    }
    if(AES_ONSITE.issue.timeSpent) {
    NEW_PORTAL.issue."Microsoft.VSTS.Scheduling.CompletedWork" = (AES_ONSITE.issue.timeSpent as Double)/3600
    }
}
if (executionInstanceName == "NEW_PORTAL") {
    if(NEW_PORTAL.issue."Microsoft.VSTS.Scheduling.Effort") {
     AES_ONSITE.issue.originalEstimate = (NEW_PORTAL.issue."Microsoft.VSTS.Scheduling.Effort" as Double)*3600
    }
    if(NEW_PORTAL.issue."Microsoft.VSTS.Scheduling.CompletedWork") {
     AES_ONSITE.issue.timeSpent = (NEW_PORTAL.issue."Microsoft.VSTS.Scheduling.CompletedWork" as Double)*3600
    }
}