Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM (Archived)

Dyn CRM: Entity Change Tracking across a multi-level entity structure (parent/child/grandchild)

Posted on by

How does CRM handle a multi-entity structure with various parent-child relationships?  In other words, can't there be some timing issue with having separate tokens for each entity?  If my process requests all updates to a PARENT entity, and then while I am processing them, someone adds a new PARENT with CHILDREN, and then when the step to get all the CHILDREN starts, it will get the new CHILD records, but it didn't get the PARENT.  I think I will still have to do it the old fashioned way and keep my own "token" so I can use the same timestamp across all entities in the structure.  Any thoughts?

*This post is locked for comments

  • Suggested answer
    ScottDurow Profile Picture
    ScottDurow 50,177 on at
    RE: Dyn CRM: Entity Change Tracking across a multi-level entity structure (parent/child/grandchild)

    Hi,

    You simply need to ensure that you retrieve the entity changes in the reverse order of the hierarchy - so retrieve children first then the parent - then re-assemble the records to insert into your target database. There would never be a situation where the child record would reference a parent record that did not already exist and so you would be able to get the record in the change tracking set.

    Hope this helps.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans