Thursday, January 20, 2011

How to write complex quires to get the data from MS Dynamic CRM 4.0 using web service.

Traditional CRM Query Attribute cannot be used to create complex queries and get the data from many entities using joins. Query attribute has ability to join many entities, but there is no way to get the data from few entities using single query. So we should go for Fetch XML.

When we wanted to generate complex queries then fetch XML also become complex. So then we think of way to generate XML using tool. I found nice tool “Fetch XML builder”, which does everything for me. It was the first tool that I found for MS CRM 4.0 and is a very simple user friendly tool that any developer can use it without any help.

Download FetchXML Builder

--Thushara Manchanayake--

No comments:

Post a Comment