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

Parent Inheritance of Child Tickets Multi-Field Values

Travis Hill_08pum3

Hello,

I am attempting something with automation that I havent messed with much before so hoping to get some clarity here.

This is the scenario:

We have Initiatives and nested under those Initiatives are Features and Enablers. We have a mutli-value field on the features and enablers that I would like to roll up to the parent initiative whenever that field is updated. The issue here is that I need the values from all of the child features and enablers to roll up continuously.

So basically the parent needs to reflect the combination from all multi field values from all of the child tickets

As an example:

Feature 1 has values A, B, C, D in the multi field value

Feature 2 has values C, D, E in the multi field value

Feature 3 has values A, E in the multi field value

Feature 4 has values F in the multi field value

The parent of these features should show values A, B, C, D, E, F in the multi field value

Additionally if Feature 2 deletes D from the multi-field value, it should still show in the parent because it is still linked in Feature 1

Any thoughts on how I could approach this? Thanks in advance.

Accepted answers

Kalyan Sattaluri_iinm1n

Hello @Travis Hill

To clarify, your trigger is field change on the feature and if that field is updated, you want to find that feature's initative, find all features/enablers of that initiative, and then copy these values over?

If so, can you tell:

Are all these issues in the same project?
Does Initiative has the same multi field values as feature?
Is this multi value field, a checkbox?

All comments

Kalyan Sattaluri_iinm1n

Hello @Travis Hill

If so, can you tell:

Are all these issues in the same project?
Does Initiative has the same multi field values as feature?
Is this multi value field, a checkbox?

Travis Hill_08pum3

Thanks for reaching out. That is exactly the scenario yes. When that trigger field is updated it should find that tickets parent then spot check all children of that parent and copy those values over, exactly!

As far as the answers to your questions above, it is yes to all three

Kalyan Sattaluri_iinm1n

Hello,

We start with issue trigger where a feature's checkbox field is edited.
Using that trigger, we know the parent initiative which is {{issue.parent}}, this gives us the key of parent initiative.
Using parent key, we find all Features / Enablers using lookupIssues JQL.
Once we have all features/enablers, we can access their check box values using {{lookupIssues.Agile Release Train.value}}
But because each issue can have multiple values, above smart value gives us a list of arrays, which looks like, [OPTION1, OPTION 2], [OPTION1, OPTION 3]
We cannot use that output format to update directly so we start cleaning the data.
We first remove the square brackets which will give us nice output of OPTION1, OPTION2, OPTION1, OPTION3
Now above is a list and we can iterate.
But to update a field like multi value check box, JSON has to be in certain format.
So we do the magic of last step, that is we iterate the above list and make it output the same list in a JSON format which can be used to update the field on the initiative.

</edit>

So, start a new rule with:

Trigger = Field Value changed., select your checkbox field as trigger field.
If condition -> Issue type == Feature & Enablers
Log Action - > {{issue.Parent Link}}
Action -> lookupIssues -> JQL => issuekey in portfolioChildIssuesOf("{{issue.Parent Link}}") and issuetype in (Features, Enablers)
Log Action -> {{lookupIssues.key}}

Please cross check my JQL for lookupIssues...

Create this rule, trigger the rule by adding/remove a value from the check box field and share the audit log. We need to see if lookupIssues gets all features/enablers

Travis Hill_08pum3

Screen Shot 2024-04-02 at 2.20.46 PM.png

Welcome!

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

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud

automation