How to return original number value of custom field and the New Value

Jocelyn Aquilina

Hi everyone,

 

I am trying to automate a part where I have a Parent ticket linked to several child tickets. Now what I want is basically to reflect the number of impacted transactions from the child tickets and the total would add up to the parent. My problem is not knowing how to reflect this whenever a user amends the number within a child ticket. I tried using changelog but no success.

E.g. 1 Parent ticket linked to 1 child ticket, child ticket has 1000 impacted transactions. Therefore Parent also has 1000 transactions. User changes from 1000 to 800, then I would expect the Parent to be changed also.

Tried the following equation basically:

Simple terms: Parent custom field value subtracted from the trigger issue custom field value and added with the new value of the same trigger issue.

Equation attempted which did not work: 

{{issue. customfield_18480}} -{{triggerIssue.changelog.Numbers.customfield_18480.fromstring}} + {{triggerIssue.changelog.Numbers.customfield_18480.tostring}}

 

Would appreciate if someone knows how to work through it or maybe find another way...

Bill Sheboy

Hi @Jocelyn Aquilina -- Welcome to the Atlassian Community!

I noticed a few things with your expression: it has extra spaces around the smart values, the changelog syntax is incorrect, and it is missing the math operator syntax.

Please try this instead, assuming your custom field is a number type:

{{#=}}{{issue.customfield_18480}} - {{#changelog.customfield_18480}}{{fromString.asNumber}}{{/}} + {{#changelog.customfield_18480}}{{toString.asNumber}}{{/}} {{/}}

The changelog smart value is relative to the trigger issue, and so there is no need to add the extra prefix.

Kind regards,
Bill