It is small but great feature to use Advanced Find to create your Fetch XML statement.
1. choose the entity you need
2. add or change the search attributes
3. add or change the columns "Spalten bearbeiten"
4. preview your result using the button "results" / "Ergebnisse"
5. download the Fetch XML / "FetchXML herunterladen"
<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false">
<entity name="account">
<attribute name="name" />
<attribute name="address1_city" />
<attribute name="telephone1" />
<attribute name="accountid" />
<order attribute="name" descending="false" />
<filter type="and">
<condition attribute="statecode" operator="eq" value="0" />
<condition attribute="address1_city" operator="eq" value="Zürich" />
</filter>
</entity>
</fetch>
I have used it to create the fetch XML statement for the AddExisting filter.
No comments:
Post a Comment