Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

Build Queries with FetchXML

[Applies to: Microsoft Dynamics CRM 2011]

FetchXML is a proprietary query language that is used in Microsoft Dynamics CRM 2011. It is based on a schema that describes the capabilities of the language. The FetchXML language supports similar query capabilities as query expressions. In addition it is 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.

Microsoft Dynamics CRM 2011 Update Rollup 12 and the Microsoft Dynamics CRM December 2012 Service Update contains performance optimizations for Quick Find queries. In FetchXML, these are specified by the isquickfindfields attribute on a filter. For more information, see Build Queries with QueryExpression and About the IsQuickFindFilter Property.

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

In This Section

Related Sections

Microsoft Dynamics CRM 2011
Send comments about this topic to Microsoft.
© 2013 Microsoft Corporation. All rights reserved.
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2014 Microsoft. All rights reserved.