You are here

FetchXML

FetchXML Field Types in SSRS

When creating reports that use FetchXML, some field types are returned with two fields, the name of the field and the name of the field with Value appended, fieldValue.

The table shows the field types that I found that have a Value version. Other CRM field types only return one field and are of type String.

FetchXML Notes

Link Entities

When retrieving attributes from linked entities it seems that attributes must have an alias otherwise you can't refer to them:

Table alias is not unique amongst all top-level table and join aliases

If you are seeing the above error, it might be due to incorrect FetchXML in the definition of a saved query such as a Quick Find view. I've encountered this on CRM 2011 with UR13 installed after modifying the filter criteria for a Quick Find view. The view includes fields from related entities.

Toolbox (CRM and others)

Tools for CRM

Item Description Location
Sitemap Editor Provides a way for users to update the site map through a user interface within Microsoft Dynamics CRM.
Subscribe to FetchXML