FetchXML syntax:
Legend:
•
Xxxx :=
à
production
•
(
) à
choice
•
| à or
•
? à optional
•
* à repeat
// à
comments
FetchXml :=
<fetch
(page='page-number')?
// start page default is 0
(count='items-per-page')?
// count default is 5000
(utc-offset='utc-offset')?
// utc-offset default is 0
(mapping='logical')?
(distinct =
('true' | 'false' | '1' | '0') )? //default false
(paging-cookie='page-cookie')?
>
<entity name='entity-name'>
Entity-Xml
</entity>
</fetch>
Example:
<fetch page=‘10’ count=‘50’ distinct=‘true’
page-cookie=‘Page1’>
<entity
name=‘account’ >
…. Put Entity-Xml
here ….
</entity>
</fetch>
•
Entity-Xml :=
•
(<all-attributes/> | <no-attrs/> |Attribute-Xml*
)
•
( Filter-Xml
| LinkEntity-Xml | Order-Xml )*
•
Attribute-Xml :=
•
<attribute name='attr-name'
•
(aggregate=(AggOp) alias='alias-name')?
•
/>
•
AggOp :=
•
(avg | min | max | count(*) |count(attribute
name))
•
Filter-Xml :=
•
<filter (type= ('or' | 'and'))? // default
is 'and' >
•
( Condition-Xml
| Filter-Xml )*
•
</filter>
•
•
LinkEntity-Xml :=
•
<link-entity name = 'entity-name'
•
// to
is the column on the remote entity
•
(to = 'column-name')?
•
//
from is the column on the local entity
•
(from
= 'column-name')?
•
(alias
= 'table-alias')?
•
(link-type = ('natural' | 'inner' |
'outer'))?
•
>
•
Entity-Xml
•
</link-entity>
•
Order-Xml :=
•
<order attribute='attr-name'
•
(descending= ('true' | 'false' | '1' |
'0')?
•
/>
