Automate the children issues progression in parent issue

[Duy Tran Quang]

Hello,

trying to notify team on the progression (status-based) of the children JSM issue. Assuming I have 2 child issues A & B with the link "is child of" my parent issue C. I would like to find out the way to share that I have 50% of my parent issue "done" and have not find out any smart value to retrieve the status of the child issues. 
Looked at the filtering smart values features but did not sort it out. 
Any help will be much appreciated.

[Trudy Claspill · Accepted solution]

Hello @Duy Tran Quang 

You could use an automation rule action Lookup Issues to get the full list of linked issues, and another Lookup Issues action to get the list of linked issues that are Done. You can save the size of each of those lists (the count of issues returned) as variables using the Create Variable action. You can then use those variables to calculate the percentage of linked issues that are done.

I set this rule to use a Manual trigger. You may need a different trigger.

For the last step I just write the value to the rule Audit Log. You would need to add steps for your intended use of the value.

[Duy Tran Quang]

Hi @Trudy Claspill 

Thank you so much for the guidance.