FetchXML Question RRS feed

  • Question

  • 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?


    Wednesday, June 27, 2012 7:59 AM

All replies

  • 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, June 27, 2012 11:41 AM
    Wednesday, June 27, 2012 11:40 AM