Hi ,
You may create a Fetch XML using the Advanced find view. Here is the sample XML for the same. you need a data from Contact so select the contact entity then goto the related Account then go the related opportunity - once you defined the crieteria then run
the query to see if that is returning the expected result then you can download the XML by clicking download fetch XML button.
<?xml version="1.0"?>
@namespace html url(http://www.w3.org/1999/xhtml); :root { font:smallVerdana; font-weight: bold; padding: 2em; padding-left:4em; } * { display: block; padding-left: 2em; } html|style{ display: none; } html|span, html|a{ display: inline; padding: 0; font-weight: normal; text-decoration: none; } html|span.block{ display: block; } *[html|hidden], span.block[html|hidden] { display: none; } .expand { display: block; } .expand:before{ content: '+'; color: red; ; left: -1em; } .collapse { display: block; } .collapse:before { content: '-'; color: red; ; left:-1em; } -<fetch distinct="true" mapping="logical" output-format="xml-platform" version="1.0">-<entity name="contact"><attribute name="fullname"/><attribute name="telephone1"/><attribute name="emailaddress1"/><attribute name="address1_stateorprovince"/><attribute name="address1_city"/><attribute name="parentcustomerid"/><attribute name="mobilephone"/><attribute name="jobtitle"/><attribute name="contact_level"/><attribute name="firstname"/><attribute name="contactid"/><order descending="false" attribute="fullname"/>-<link-entity name="account" alias="ag" to="contactid" from="primarycontactid">-<link-entity name="opportunity" alias="ah" to="accountid" from="parentaccountid">-<filter type="and"><condition attribute="opportunityid" value="{4585F31B-7769-E011-8C05-005056B8537B}" uitype="opportunity" uiname="Processed Materials" operator="eq"/></filter></link-entity></link-entity></entity></fetch>
