fetch element

The root element of a FetchXml query.

Learn how to query data using FetchXml.

Example

<fetch>
  <entity name='account' />
</fetch>

Attributes

Name	Required?	Description
aggregate	No	Boolean value to specify that the query returns aggregate values. Learn about aggregating data
aggregatelimit	No	Set a limit below the standard 50,000 record aggregate limit. Learn about aggregate limits
count	No	Positive integer value to specify the number of records to return in a page. Learn about paging results
datasource	No	When using Dataverse long term data retention, set datasource to 'retained' to indicate the query is for retained rows only. Learn more about Dataverse long term data retention
distinct	No	Boolean value to specify that duplicate rows not be included in the results. Learn more about returning distinct results
latematerialize	No	Boolean value to direct the query to be broken up into smaller parts and reassemble the results before returning them. Using latematerialize might improve performance for some long-running queries. Learn more about using Late Materialize query.
no-lock	No	Legacy setting to prevent shared locks on records. No longer necessary.
options	No	A string value to apply one or more SQL optimizations. See Options
page	No	Positive integer value to specify the page number to return. Learn about paging results
paging-cookie	No	String value from a previous page of data to make retrieving the next page of data more efficient. Learn about paging results
returntotalrecordcount	No	Boolean value to specify whether the total number of records matching the criteria is returned. Learn how to count rows using FetchXml
top	No	Positive integer value to specify the number of records to return. This value can't exceed 5,000. Don't use top together with the page, count, or returntotalrecordcount attributes. Learn more about limiting the number of rows
useraworderby	No	Boolean value to specify that choice column data sorting should Use Raw Order By mode. This sorts the choice options by the integer value. Without this, the default is to sort choice columns using the choice label values.

Child elements

Name	Occurrences	Description
entity	1	Specifies the child element for a fetch element, the 'parent entity' for the query. Only one entity is allowed.

Options

Important

Only apply these options when recommended by Microsoft technical support. Incorrect use of these options can damage the performance of a query.

Use these values with the options attribute to specify SQL Server hints to apply to the query. When more than one option is set, separate them by commas.

options='OptimizeForUnknown,DisableRowGoal,Recompile'

FetchXML option	SQL Server hint
OptimizeForUnknown	Optimize for unknown
ForceOrder	Force Order
DisableRowGoal	Hint: DISABLE_OPTIMIZER_ROWGOAL
EnableOptimizerHotfixes	Hint: ENABLE_QUERY_OPTIMIZER_HOTFIXES
LoopJoin	Loop Join
MergeJoin	Merge Join
HashJoin	Hash Join
NO_PERFORMANCE_SPOOL	NO_PERFORMANCE_SPOOL
ENABLE_HIST_AMENDMENT_FOR_ASC_KEYS	Hint: ENABLE_HIST_AMENDMENT_FOR_ASC_KEYS

More information: Hints (Transact-SQL) - Query