Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM (Archived)

modifiedon attribute when dealing with 1:N relationships

Posted on by 10

I am working with a customer to integrate their contact and related entities into our platform. The issue I am facing is making sure that we are getting the most recent contact and related entity data.

For example: each contact can be registered for multiple courses. contacts are being grouped by course on our platform. That contact's status within the course can change and our platform must reflect this change in a timely manner. We query all contacts with a modifiedon date in the past 30 mins every 30 mins (the client does not have the resources to push to our API) and then make subsequent queries for their courses. The question has arisen what happens when a course status has changed for a contact (this information is being stored on an intersect entity called contact_course)--is that change reflected in the contact record by the contact's modifiedon attribute or does the modifiedon attribute only change on the contact_course intersect entity? From what I can see in their dashboard the relationship is defined as referential and my guess is no. But if the contact was considered the parent of the intersect table would the modifiedon attribute change for the contact if the contact_course entity was modified?

*This post is locked for comments

  • David Jennaway Profile Picture
    David Jennaway 14,063 on at
    RE: modifiedon attribute when dealing with 1:N relationships

    As per the previous post, the modifiedon field will only change on the contact_course intersect entity, so it would be best to query that for changes. If you need to have the modifiedon changed on the contact, you could create a workflow on the contact_course entity to automatically update a field on the contact (updating a field to the same value is sufficient) which will update modifiedon on the contact. However, this would add a bit of extra load on the overall system

  • Suggested answer
    Adrian Begovich Profile Picture
    Adrian Begovich 21,009 Super User 2024 Season 2 on at
    RE: modifiedon attribute when dealing with 1:N relationships

    Hi Eli Goodwin,

    The modifiedon value will change on the contact_course intersect entity. You will need to alter your query so that it retrieves all contacts that have a modifiedon date in the past 30 mins and all contacts linked to a contact_course intersect entity that has been modified in the last 30 minutes.

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,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans