<div>
Thanks for the SDK snippet, I already had the sample code as my base. &nbsp;The real gem you supplied was the <a href="http://www.stunnware.com" rel="ugc">www.stunnware.com</a>&nbsp;link which lead me to the FetchXML tool he has developed that generates the .Net query from a very easy to use GUI<br />
<br />
<a href="http://www.stunnware.com/crm2/topic.aspx?id=FindingData6" rel="ugc">http://www.stunnware.com/crm2/topic.aspx?id=FindingData6</a><br />

</div>


Thanks for the SDK snippet, I already had the sample code as my base.  The real gem you supplied was the www.stunnware.com [http://www.stunnware.com] link which lead me to the FetchXML tool he has developed that generates the .Net query from a very easy to use GUI

http://www.stunnware.com/crm2/topic.aspx?id=FindingData6 [http://www.stunnware.com/crm2/topic.aspx?id=FindingData6]


<div>
<div class="content wysiwyg-content">
Hi there,<br />
I am developing a CRM 3.0 Callout in VB.net that uses a service.retrievemultiple statement that will retrieve the list of CRM 3.0 system users who own the contacts that a marketing campaign email or letter has been sent to.<br />
<br />
I am after some assistance with the query expression, I have created what i think is the correct Advanced Find in the CRM interface as a sanity check that the general concept works but translating this into the query expression has me a little lost.<br />
<br />
The Advanced find for the query would be as follows:<br />
Look For: Users<br />
Contacts (owners)<br />
&nbsp; &nbsp; &nbsp;Activity Parties(party)<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Activity(E-Mail)<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Subject &nbsp; Equals &nbsp; &nbsp;XXXXX(Search Term)XXXXX<br />
<br />
Is there anyone who knows enough to translate this search into a retirevemultiple query or could point me in the right direction?<br />
<br />
Alistair
</div>
</div>


Hi there,
I am developing a CRM 3.0 Callout in VB.net that uses a service.retrievemultiple statement that will retrieve the list of CRM 3.0 system users who own the contacts that a marketing campaign email or letter has been sent to.

I am after some assistance with the query expression, I have created what i think is the correct Advanced Find in the CRM interface as a sanity check that the general concept works but translating this into the query expression has me a little lost.

The Advanced find for the query would be as follows:
Look For: Users
Contacts (owners)
     Activity Parties(party)
             Activity(E-Mail)
                     Subject   Equals    XXXXX(Search Term)XXXXX

Is there anyone who knows enough to translate this search into a retirevemultiple query or could point me in the right direction?

Alistair

Microsoft CRM 3.0 .Net Query Expression help

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.

.NET Programming

A contact manager in its most basic form is a software program that enables users to easily store and find contact information, such as names, addresses and telephone numbers. Sophisticated contact managers provide calendar sharing features and allow several people in a company to access the same database. Some contact management systems have evolved into customer relationship management (CRM) systems to analyze and plan for an organization’s interaction with current and future customers.

Contact Management

Microsoft Dynamics is a line of enterprise resource planning (ERP) and customer relationship management (CRM) software applications. Dynamics can be used with other Microsoft solutions, such as SharePoint, Yammer, Office 365, Azure and Outlook. Dynamics ERP comprises a group of enterprise-resource-planning products includes Dynamics AX (formerly Axapta), a multi-language, multi-currency enterprise software with business management features for financial, human resources, and operations management; Dynamics GP (formerly Great Plains Software); Dynamics NAV (formerly Navision) for financials, supply chain, and people; Dynamics SL (formerly Solomon IV)for project-driven organizations; Dynamics C5 (formerly Concorde C5) for manufacturing, supply chains, analytics and electronic commerce; and Dynamics CRM.