Join and filter condition between CRM entities using Odata query -


can please tell me odata equivalent query below fetchxml query?

<fetch distinct="false" mapping="logical" output-format="xml-platform" version="1.0"> <entity name="customeraddress"> <attribute name="name"/> <link-entity name="contact" alias="ab" to="parentid" from="contactid"> <filter type="and"> <condition attribute="statecode" value="0" operator="eq"/> </filter> </link-entity> </entity> </fetch> 

i looked lot , tried mentioned here: filter on expanded entities in odata doesn't work.

unfortunately not possible build odata query include expand on related entity , filter on if work dynamics crm 2016 new webapi can use clear fetchxml data querying. recheck following articles: http://debajmecrm.com/2016/01/04/leverage-web-api-to-execute-your-system-views-personal-views-and-custom-fetchxml-in-dynamic-crm-2016/ https://community.dynamics.com/crm/b/crminogic/archive/2015/12/28/execute-fetchxml-using-web-api-in-dynamics-crm-2016


Comments

Popular posts from this blog

how to insert data php javascript mysql with multiple array session 2 -

multithreading - Exception in Application constructor -

windows - CertCreateCertificateContext returns CRYPT_E_ASN1_BADTAG / 8009310b -