25 Nov’19

D365 GeneralJoin on Multiple related Entity in Dynamics 365 CRM using fetch XML

  1. Click on advanced find on header section to open a query builder window, refer below image.

2. After clicking, a new window will be opened wherein you have to create query as per your requirement, here suppose we have three related entity , 1st entity have lookup of 2nd and 2nd have lookup of 3rd and we have to fetch data from all the three entity for achieving the same we can use joins below steps will guide you how to make join quarries.

3. In the above image selected Leasing is the base entity (1st entity)

4. Now, we will select the related entity (2nd entity), refer below image. Here related entity will be Leasing unit.

5. Now, we will select the 3rd related entity. Here related entity will be Unit register, refer below image.

6. After all the above steps, the window will look like below image.

7. In, the above image, by clicking on the result it will show you the result of a query and when you click on download fetch XML it will download the query in an XML file on the system.

Written by

Tejesh Sharma

D365 CRM Consultant

Leave a Reply

Your email address will not be published. Required fields are marked *

Want to streamline your business processes?

  • This field is for validation purposes and should be left unchanged.

Recent Articles

  • How to create Dynamics 365 Finance & Operations (formerly Dynamics AX) connection in SSIS

    12 December’ 2019

    Introduction: Creating a Connection is one of the first Steps during the integration of data. While performing Integrati...

    Read more
  • How to create AX (D365 F&0) Connection in SSIS

    12 December’ 2019

    Introduction: Creating a Connection is one of the first Steps during integration of data. While performing Integration w...

    Read more
  • First cut review of new D365 Project Service

    12 December’ 2019

    The new Project Service coming up is a much-advanced version of PSA. Even more, than it will be called as Project Servic...

    Read more
  • Business Central Wave 2 Features – Section 4

    11 December’ 2019

    Introduction: In this blog, I will be attempting to provide information about the new Modern Client features of Business...

    Read more
  • Business Central Wave 2 Features – Section 5

    11 December’ 2019

    Introduction: In this blog, I will be attempting to provide information about the new Modern Client features of Business...

    Read more

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close