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.

See also

Query data using FetchXml
Use FetchXml to retrieve data
Select columns using FetchXml
Join tables using FetchXml
Order rows using FetchXml
Filter rows using FetchXml
Page results using FetchXml
Aggregate data using FetchXml
Count rows using FetchXml
Optimize performance using FetchXml
FetchXml sample code