Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Related "Regarding...
Microsoft Dynamics CRM (Archived)

Related "Regarding" Records

(0) ShareShare
ReportReport
Posted on by Žarko Radevic 4

Hi, I am working on a custom web application which should display account related entities' information (related activities, opportunities, cases and contacts). It is easy to display entities that are directly bound to an account but I would like to include the functionality of related "regarding" records view which is available when you display these entities from the Details section of the account form. I would like to know how exactly CRM queries these information against SQL database.

 Thanks in advance

Zarko

*This post is locked for comments

  • Žarko Radevic Profile Picture
    Žarko Radevic 4 on at
    Re: Re: Re: Re: Related "Regarding" Records

    Inogic, you solved my problem, thank you!!![quote user="Inogic"]

    Hi Zarko,

    If you want to go the CRM web services way... Dynamics CRM makes available Rollup Messages that can be used to ensure that the data displayed in CRM associated views match the results in your custom view.

    Rollup Messages are available for all entities that have the "Related Records" view available in CRM associated views.

    You can download the CRM SDK and lookup for Rollup Message.

    HTH

    Sam

     

    [/quote]
  • Inogic Profile Picture
    Inogic 408 on at
    Re: Re: Re: Related "Regarding" Records

    Hi Zarko,

    If you want to go the CRM web services way... Dynamics CRM makes available Rollup Messages that can be used to ensure that the data displayed in CRM associated views match the results in your custom view.

    Rollup Messages are available for all entities that have the "Related Records" view available in CRM associated views.

    You can download the CRM SDK and lookup for Rollup Message.

    HTH

    Sam

     

  • alf Profile Picture
    alf 17,915 on at
    Re: Re: Re: Related "Regarding" Records

    Hi Zarko,

    We have have done quite a bit is examine the crm views themselves.  You can go to views and look at how they are constructed.  Just be careful not to change anything or do it on a test system just in case.  This can help a ton to learn how crm internally is looking at the data.

  • Žarko Radevic Profile Picture
    Žarko Radevic 4 on at
    Re: Re: Related "Regarding" Records

    Alex, thank you for your effort, I know that the view is taking under consideration activities of other account related entities. What I was hoping to get is a documented query about how CRM queries for this data internally, so that there are no discrepancies between the original Related Regarding Records view and the data my application is displaying. Any hint would be appriciated.

     Regards

  • alf Profile Picture
    alf 17,915 on at
    Re: Related "Regarding" Records

    Hi Zarko,

    For this you will need to do a recursive query.

    For example, lets say you have accounts/contacts/cases.  You will need to fetch all activities for the account, then all activities for the related contacts, and all activities for the cases.

    What i would recommend is first fetch all account guids, and all related contacts guids.

    Then fetch all activities related  opportunity/cases/etc related to your list of guids. 

     

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey Pt 2

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,540 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans