Need to create an one time automation update Epics with the time tracking of their child issues

[Rosana Casilli]

Good afternoon all!

I already created an automation to update the time tracking of the epics when the time tracking of their childs is added.

Now I need to create a one time automation in order to update those epics that has 0 time in worklog and they children issues  has worklog added. 

I have been trying different automation but I there is no way I can achive what I want. 

Can anybody help me on this?

Thanks in advance.,

Ro

[Shawn Doyle - ReleaseTEAM]

Hi @Rosana Casilli 

Before automation existed I would do the following.

I'd create a filter to find all child issues with time logged, and display issue numbers of both the child and the epic as well as the time tracking field from that epic.

Export this to excel.  Sort by epic, do the math for the epics (assuming multiple children per epic), and update the time tracking column. Save to CSV (formatted for just Epic Number and Time tracking) and import back to Jira to update the epic time tracking.

Now with automation,

1. Start with JQL to find children with work logged, grab the epic number and the time tracking field. 
2. Branch per child found.
3. This is where it gets tricky, you want to check both if time tracking is empty in the epic AND if it has a value that we should add to it.  I'm not sure of a clever way to figure out the 2nd part without being able to cache values between the branch runs, maybe some time math with the modification date, but I would assume that can be error prone. 
4. Once you find a way to determine it is ok to add to the time tracker field with the value of the child work logged, then update the epic with that value.

Depending on how many epics you need to update, it might be easier to do it the old school way.  

However, there is also the question of "Why?" Some would say "do not track time at the epic level", while I don't disagree, I avoid those people.

[Evgenii]

Hi, @Rosana Casilli 

I once made something similar. It works with another time fields, but I think, it can help you in finding a way to solve your task.

[Trudy Claspill]

Hello @Rosana Casilli 

Can you tell us more about what you've tried and how it has not worked?

You should be able to create a rule that uses a Scheduled trigger and a JQL to select the Epics.

Then use a Lookup Issue action to look up all the child issues of that Epic.

Which time tracking elements in the Epic do you want to set? Which ones you want to set will determine which actions would be used next.