Fetchxml ile 2 link entity ile or sorgusunun yapılması
Aşağıdaki örnek gibi yapabilirsiniz
<fetch version=”1.0″ output-format=”xml-platform” mapping=”logical” distinct=”false” >
<entity name=”salesorder” >
<attribute name=”name” />
<attribute name=”customerid” />
<attribute name=”totalamount” />
<attribute name=”new_sozlesmebitistarihi” />
<attribute name=”new_sozlesmebaslangictarihi” />
<attribute name=”statuscode” />
<attribute name=”salesorderid” />
<order attribute=”name” descending=”false” />
<link-entity name=”account” from=”accountid” to=”customerid” visible=”false” link-type=”inner” alias=”alaccount” >
<attribute name=”accountnumber” />
</link-entity>
<link-entity name=”contact” from=”contactid” to=”new_sevkmusterisi” link-type=”outer” alias=”alcontact” />
<filter type=”and” >
<filter type=”or” >
<condition entityname=”alcontact” attribute=”parentcustomerid” operator=”eq” uiname=”TestFirma” uitype=”account” value=”{C64D478C-AFF6-E711-A951-000D3A296433}” />
<condition entityname=”alaccount” attribute=”accountid” operator=”eq” uiname=”TestFirma” uitype=”account” value=”C64D478C-AFF6-E711-A951-000D3A296433″ />
<condition entityname=”alaccount” attribute=”parentaccountid” operator=”eq” uiname=”TestFirma” uitype=”account” value=”C64D478C-AFF6-E711-A951-000D3A296433″ />
</filter>
</filter>
</entity>
</fetch>
Yorum gönder