Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Calculate field in Parent using values from Childs

Nawaaz SOHAWON February 15, 2023

I need an automation which does the follow:

Trigger: Field value change in CHILD ticket

Branch/related issues: Identification of PARENT through JQL

Action: Update of field in Parent by doing an average of values from the same fields from all CHILD tickets linked to the PARENT

I have configured the trigger and branch/related issue section but cannot find any smart values which retrieves values from CHILD tickets.

Linked Issues have this smart value: {{issue.issuelinks.Issue."FIELDNAME".average}}

Any one ever used the smart value for the parent/child link?

 

1 answer

0 votes
Trudy Claspill
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
February 15, 2023

Hello @Nawaaz SOHAWON 

I recommend that within the branch you use a Lookup Issues action to retrieve all the "child" issues of the parent. Then you can average the values thus:

{{lookupIssues.<fieldname>.average}}

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Site Admin
TAGS
AUG Leaders

Atlassian Community Events