Microsoft Dynamics CRM (Archived)

How to write plugin to Update Child records when Parent record updated

(0) Share

Report

Posted on by Community Member

How to write plugin to Update Child records when Parent record updated (lookup filed and option set )

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (1)

Abhishek Gupta 2,003 on at

Like (0)

Report

RE: How to write plugin to Update Child records when Parent record updated

HI,

Write a code activity to fetch all the child records using query expression. Once you get all child records iterates through collection to update child record. Finally trigger your plugin on update of parent record. Make use of filtering attributes on Parent record name attribute or Option set attribute.

Thank you

Abhishek

If found useful, please mark the answer as verified

Was this reply helpful? Yes No
Verified answer

gdas 50,091 Moderator on at

Like (1)

Report
RE: How to write plugin to Update Child records when Parent record updated

Hi ,

You need to get the entity id of the parent record in the plugin to retrieve the child records (use retrievemultiple message and pass fetchXML passing entity id ). Once you get the child record loop through the entity collection and using organization service update the child record.

public void Execute(IServiceProvider serviceProvider) { if (serviceProvider == null) throw new ArgumentNullException("serviceProvider"); var context = (IPluginExecutionContext)serviceProvider.GetService(typeof(IPluginExecutionContext)); var serviceFactory = (IOrganizationServiceFactory)serviceProvider.GetService(typeof(IOrganizationServiceFactory)); var service = serviceFactory.CreateOrganizationService(context.UserId); if (context.InputParameters.Contains("Target") && context.InputParameters["Target"] is Entity) { Entity targetAccount = (Entity)context.InputParameters["Target"]; if (targetAccount.Contains("telephone1")) { // Retrieve all contact for this account var fetch = @"<fetch no-lock='true' > <entity name='contact' > <attribute name='contactid'/> <filter> <condition attribute='parentcustomerid' operator='eq' value='{0}' /> </filter> </entity> </fetch>"; var fetchXML = string.Format(fetch, targetAccount.Id); var allContacts = service.RetrieveMultiple(new FetchExpression(fetchXML)).Entities; // Iterate through all contact record and update the phone number from account foreach (var contactEnt in allContacts) { Entity contactToUpdate = new Entity(contactEnt.LogicalName, contactEnt.Id); contactToUpdate["telephone1"] = targetAccount["telephone1"]; service.Update(contactToUpdate); } } } }

Was this reply helpful? Yes No
Suggested answer

Dynamics365 Rocker 7,755 on at

Like (0)

Report

RE: How to write plugin to Update Child records when Parent record updated

You have to follow below steps:

1.Register Plugin on message update and Entity will be parent record Entity.

2. Select fields in filter Attribute on which you want this plugin get execute.

3. In code, You have to fetch all children records of parent. (You will get parent record id from plugin Target)

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

RE: How to write plugin to Update Child records when Parent record updated

.. You can use Flow without Coding. Fetch the Childs, loop and Update.

Was this reply helpful? Yes No