Contents tagged with FetchXML

  • FetchXML in Dynamics CRM

    Hello everybody,

    today I want to write few words about Quering CRM data. I discovered as started FetchXML. 

    Initially I was ver sceptical about xml for quering data. First of all because of debugging xml is something that I dislike, also I prefer SQL or Linq, and was quite puzzled, why we can need FetchXML.

    But with time I realized that with FetchXML you can easily do grouping operations on Dynamics CRM data. And that is something that can make life of developer easier.

    Consider following xml for FetchXML:

    <fetch distinct='false' mapping='logical' aggregate='true'>

        <entity name='opportunity'>

          <attribute name='statecode' groupby='true' alias='state' />

          <attribute name= … more