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
Post a Comment