Sign in
Microsoft.com
 
Microsoft
 
 
 
Microsoft >
> 
> 
FetchXML Question

Voorgesteld antwoord FetchXML Question

  • Wednesday, 27 June 2012 7:59 AM
     
     
    Sign In to Vote
    0

    Hi,

    FetchXML queries seem to be limited, we can not make special joint as in SQL. We can not also insert operator "or" and "and" between different attribute of different tables ..

    Is this possible or when FetchXml is very limited?

    Thank

     

All Replies

  • Wednesday, 27 June 2012 11:40 AM
     
     Proposed Answer Has Code
    Sign In to Vote
    0

    yes you are right, there are some limitation to fetch xml.

    you cannot use and/or operator when comparing different entities but you can when you are comapring the attributes of same entity

    <filtertype='or'><conditionattribute='gradefilter'operator='eq'value='0'/><filtertype='and'><conditionattribute='minimumgrade'operator='ge'value='1'/><conditionattribute='maximumgrade'operator='le'value='12'/></filter></filter>

If you are trying to use reports then you can use filtered views to create sql queries. 
    it is only possible for on premise deplyment.
    I hope this helps.

    If you find this post helpful then please "Vote as Helpful" and "Mark As Answer". Amreek Singh Senior CRM Consultant CDC Praxa Sydney, Australia http://mscrmshop.blogspot.com http://crm2011usersettings.codeplex.com

    • Proposed As Answer by Amreek Singh Wednesday, 27 June 2012 11:41 AM
    •