Knowledge found and lost while working with Microsoft Dynamics CRM
RSS icon Home icon
  • Creating a FetchXML 'In' clause for a CRM query

    Posted on October 21st, 2006 mitch Print Print 1 comment

    Darren Neimke has an excellent article describing a couple of really interesting techniques for those of us working with Microsoft CRM's FetchXML query language.

    He discusses using the IN operator as well as how to reverse-engineer a standard CRM QueryExpression to obtain the FetchXML code.

    For those of you who are not developers and want to know what the heck I'm talking about: FetchXML is a method of generating an CRM database query using an series of pre-defined instructions written in XML.  You perform a query operation using the XML instructions and CRM will return to you a list of CRM records that match your criteria.

    If you've ever used CRM's Advanced Find feature, then you've actually generated something similar to FetchXML during that process but never known it.

    Development, Dynamics CRM
    1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
    Loading ... Loading ...
    2,795 views
     

    One response to “Creating a FetchXML 'In' clause for a CRM query”

    1. [...] The first deals with obtaining the FetchXML code used by CRM internally to perform searches using the Advanced Find feature.  This is really great because it will save CRM developers tons of time. Instead of creating the query by hand, you can utilize CRM itself to create and test the query, then take the FetchXML code used by the query and integrate it into your own code. [...]

    Leave a reply