Share
ReportHi
can you please any one explain me where we will use Joins in MS CRM
i know how to use joins in SQL Server but i font know in CRM
Thanks.
*This post is locked for comments
You’re offline. This is a read only version of the page.
55
Hi
can you please any one explain me where we will use Joins in MS CRM
i know how to use joins in SQL Server but i font know in CRM
Thanks.
*This post is locked for comments
Hi Srinivas ,
Join in Dynamics CRM is similar concept like SQL Join . Dynamics CRM does not support direct access of database while working on Dynamics CRM , For example I can say to retrieve related record let say you want to retrieve customer information as well as customer order details using query. So you can retrieve data from entity many ways like using FetchXML , Query Expression , WEB API , Organization Service and also new XRM.WebAPI method .
All the method having some pros and cons which you need to aware before using them. For example you can not do right outer join using FetchXML , where as using query expression you can not do aggregation but fetchXML you can do .
Here is some of the reference you can go through -
FetchXML-
msdn.microsoft.com/.../gg328332.aspx
QueryExpression -
msdn.microsoft.com/.../gg328300.aspx
WEB API-
docs.microsoft.com/.../web-api-samples
You can create API request very simple way using CRMRestbuilder - download CRMRestBuilder and import the solution to your Dynamics 365 instance.
For more information have a look below article -
goutamdascrm.wordpress.com/.../why-dynamics-365-web-api
Using Xrm.WebApi
Hi
While creating the custom SSRS reports, We use INNER JOINs in MS CRM.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (