web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
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

I have the same question (0)
  • alf Profile Picture
    alf 17,915 on at

    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. 

     

  • Žarko Radevic Profile Picture
    Žarko Radevic 4 on at

    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

    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.

  • Inogic Profile Picture
    Inogic 756 on at

    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

     

  • Žarko Radevic Profile Picture
    Žarko Radevic 4 on at

    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]

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
AS-17030037-0 Profile Picture

AS-17030037-0 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans