FetchXml reference

Use these elements to compose a query using FetchXml to retrieve data from Dataverse. Learn how to query data using FetchXml.

Use these elements to define queries to retrieve data in the following use cases:

This reference does not include elements or attributes used in defining views for model-driven application or reports that use FetchXml to define the query. Learn more about customizing model-driven app views with code.

Element	Description
all-attributes	Indicates that all non-null column values for each row are returned. It is the same as not adding any attribute elements. We don't recommend using this element for most cases.
attribute	Specifies a column from an entity or link-entity to return with a query.
condition	Specify conditions for entity and link-entity row values which must be true to return the row. The condition operator attribute specifies how to evaluate the values.
entity	Specifies the child element for a fetch element, the 'parent entity' for the query. Only one entity is allowed.
fetch	The root element of a FetchXml query.
filter	Specify complex conditions for an entity or link-entity to apply to a query.
link-entity	Joins a table related to the entity or link-entity to return additional columns with the result. Also used with filter elements to apply conditions on column values in related tables.
order	Specifies a sort order for the rows of the results.
value	Specify values for operators that require multiple values.

Feedback