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"/>









    Thursday, December 22, 2016 6:45 AM

All replies

  • Hello Justin, 

    I hope below link could help you.


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


    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