Fetch XML Entity Link RRS feed

  • Question

  • hi all,
    i want to add entity link like this:

    "select name from account inner join account_activity on account.accuont_id !=account_activity.accuont_id "

    how can i do it in Fetch XML
    what is the similar to != in fetch x

    i tried to use Fetch xml builder , it just have the following relation type : natural-inner-outer

    i need relation like not exist in !!

    • Edited by Dany85 Monday, July 27, 2009 9:18 AM more info
    Monday, July 27, 2009 8:19 AM


All replies

  • Maybe too late for the original poster, but for reference FetchXml does not support this type of join (which I think you should have written as a NOT IN with a subquery in SQL). Fetch only supports the equlity opertator on inner and outer joins

    Microsoft CRM MVP - http://mscrmuk.blogspot.com  http://www.excitation.co.uk
    Wednesday, August 5, 2009 1:15 PM
  • Hi Dany,

    Here is the sample code include  !=

    <fetch mapping='logical' distinct='true'>

    <entity name='contact'>

    <attribute name='ownerid'/>

    <order attribute='ownerid'/>

    <link-entity name='systemuser' from='systemuserid' to='ownerid' link-type='inner'>

    <filter type='and'>

    <condition attribute='isdisabled' operator='ne' value='false'/>




    Thanks & Regards

    Wednesday, August 5, 2009 1:25 PM