You’re offline. This is a read only version of the page.
35
Hi Experts ,
Can someone please help me to fix the below Fetch XML . Error occured on executing the fetch XML. attached the screenshot below
Thanks in advance.
<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false" >
<entity name="ipx_opportunityline" >
<attribute name="ipx_opportunitylineid" />
<attribute name="ipx_totalproductiontoolsalesusd" />
<attribute name="ipx_totalproductionpartsales" />
<attribute name="ipx_gm" />
<attribute name="ipx_ipd" />
<attribute name="ipx_ipdsite" />
<attribute name="ipx_plantregion" />
<attribute name="ipx_reasonforlostrfq" />
<attribute name="ipx_entityordivisoninterplexplantresponsible" />
<attribute name="ipx_producttype" />
<attribute name="ipx_ppdfamily" />
<attribute name="ipx_technologyused" />
<attribute name="ipx_levelofengagement" />
<attribute name="ipx_ipdpmcontact" />
<filter type="and" >
<condition attribute="ipx_opportunitylineid" operator="eq" value="C38A4532-5D23-E711-814F-E0071B6ACF71" />
<condition attribute="statecode" operator="eq" value="0" />
</filter>
<order attribute="ipx_totalproductiontoolsalesusd" descending="false" />
<link-entity name="ipx_ipx_opportunityline_ipx_services" from="ipx_opportunitylineid" to="ipx_opportunitylineid" link-type="outer" intersect="true" >
<link-entity name="ipx_services" from="ipx_servicesid" to="ipx_servicesid" alias="seg" >
<link-entity name="opportunity" from="opportunityid" to="ipx_opportunitylineitemid" intersect="true" link-type="outer" alias="oppy" >
<attribute name="ipx_programname" />
<attribute name="ipx_opportunityowner" />
<attribute name="parentaccountid" />
<attribute name="ipx_rfqnumber" />
<attribute name="ipx_name" />
<attribute name="ipx_servicesid" />
</link-entity>
</link-entity>
</link-entity>
</entity>
</fetch>
Hi partner,
According to the error message, please check the related field name (not display name) between "ipx_services" and "opportunity" in "ipx_services".
If there is the field named "ipx_opportunitylineitemid" in entity "ipx_services".
About "link-entity" you could refer to the following links.
https://stackoverflow.com/questions/53216249/understanding-link-entity-in-fetchxml
Best Regards,
Leo
Share
Report
All responses (
Answers (
