How to update some custom field in task from JQL with a sub-task specific condition
Hi Experts! :)
I have created several automations that add up the days of these split by component of the various sub-tasks, now these automations work correctly, and they start automatically any original estimate of a sub-task is edited it is updated on the relative parent task with the sum of the days of all the sub-tasks that have a certain components.
I'm posting the screens from the automation that works and that fires when I modify when any sub-task (in this example I'm going to update the "Gu Cedacri "custom field in task. Which contains the sum of the original estimates of the sub-tasks with "Cedacri" components for that specific task )
Now I will to make an new automation that triggers manually that goes to update ALL the tasks massively based on specific sub-tasks condition, this would be used to update the Gu "component name" fields (eg: Gu Cedacri, gu customtool etc ...) for all existing tasks.
I write here what I would like to do specifically:
1) I retrieve a certain number of TASK with a JQL (e.g.: project = COMPANIES and issuetype = Task and status != Closed)
2) Loop\iterate on those tasks and for each task I go to do the sum of the original estimates present in the sub-tasks connected with the same component (e.g. task 1 has 3 sub-tasks of which 2 with Cedacri component and 1 with customtool component)
3) I get the sum of the days of those with Cedacri component and update the custom field present on the TASK “gu Cedacri” (if it were possible to update the other components as well (e.g.: gu customtool with the sum of the customtool components separately in order to create a single automation)
4) End of the cycle
