TechNet
Export (0) Print
Expand All

Build queries with FetchXML

 

Applies To: CRM 2016 on-prem, CRM Online

FetchXML is a proprietary query language that is used in Microsoft Dynamics CRM Online 2016 Update and Microsoft Dynamics CRM 2016 (on-premises). It’s based on a schema that describes the capabilities of the language. The FetchXML language supports similar query capabilities as query expressions. In addition, it’s used as a serialized form of query, used to save a query as a user-owned saved view in the userquery entity and as an organization-owned saved view in the savedquery entity.

A FetchXML query can be executed by using the IOrganizationService.RetrieveMultiple method. You can convert a FetchXML query to a query expression with the FetchXmlToQueryExpressionRequest message.

For information about how to use LINQPad to work with FetchXML, see this blog post: Getting FetchXML from LINQPad.

For information about a utility that you can use to convert SQL scripts to FetchXML, see SQL2FetchXML Help.

Microsoft Dynamics CRM 2016 and CRM Online

© 2016 Microsoft. All rights reserved. Copyright

Community Additions

Show:
© 2016 Microsoft