Update a service offering when the related service is updated with a transform map

[Patrick Cavanau]

Hello Community, 

I have made a transform map that updates services from an excel sheet. We match the service name and then update the owned by and department fields. I was wondering if it would be possible to then update the same fields on the service offerings that have that service as the parent using the same transform map. 

Thank you for any advice! 

[Patrick Cavanau]

I am currently using an OnAfter Transform script but I am not sure if this is the correct way to do it, as it is not working.

[debendudas]

Hi @Patrick Cavanau ,

You are following the correct way, just update the addQuery condition as below:

child.addQuery("parent", target.sys_id);

If this solution helps you then, mark it as accepted solution ‌‌✔️ and give thumbs up 👍! 

[Patrick Cavanau]

Thank you for this, 

I have added this and it is still not working as expected.

[debendudas]

Great! Happy to help.

If this solution helps you then, mark it as accepted solution ‌‌✔️ and give thumbs up 👍!