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 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