locked
Convert FetchXML to QueryExpression RRS feed

  • Question

  • Hi,

    I understand the syntax of FetchXML and now studying QueryExpression. Could someone convert this FetchXML to QueryExpression? 

    Thanks a lot!

    -<fetch distinct="true" mapping="logical" output-format="xml-platform" version="1.0">


    -<entity name="contact">

    <attribute name="fullname"/>

    <attribute name="contactid"/>

    <order descending="false" attribute="fullname"/>


    -<link-entity name="listmember" intersect="true" visible="false" to="contactid" from="entityid">


    -<link-entity name="list" to="listid" from="listid" alias="ap">


    -<link-entity name="campaignactivityitem" intersect="true" visible="false" to="listid" from="itemid">


    -<link-entity name="campaignactivity" to="campaignactivityid" from="activityid" alias="aq">


    -<link-entity name="phonecall" to="activityid" from="regardingobjectid" alias="ar">


    -<filter type="and">

    <condition attribute="activityid" value="{A0F74029-C2C5-E611-80DC-001DD8B71C01}" uitype="phonecall" uiname="PC_020" operator="eq"/>

    </filter>

    </link-entity>

    </link-entity>

    </link-entity>

    </link-entity>

    </link-entity>

    </entity>

    </fetch>

    Thursday, December 22, 2016 6:45 AM

All replies

  • Hello Justin, 

    I hope below link could help you.

    http://www.aayushsingh.in/2014/11/conditionexpression-operators-and.html

    If I have answered please mark as 'Answer'. If was just helpful, please vote.

    Thanks 

    Ashok J



    Thursday, December 22, 2016 10:27 AM
  • CRM already have message called "FetchXmlToQueryExpression", it will convert the FetchXml to Query Expression , and if you want viceversa you have QueryExpressionToFetchXmlRequest 

    MaKeer|<a href="http://wp.me/1AkRL" target="_blank">myencounterwithcrm.wordpress.com </a>

    Sunday, February 5, 2017 3:52 AM