×

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