CRMQuery.CreateAndRetrieve Method

The CreateAndRetrieve method creates a new query and then retrieves it.


[Visual Basic .NET]
Public Function CreateAndRetrieve(
  ByVal Caller As CUserAuth,
  ByVal objectType As ObjectType,
  ByVal QueryXML As String
) As String
public string CreateAndRetrieve(
  CUserAuth  Caller,
  ObjectType  objectType,
  string  QueryXML
public: String* CreateAndRetrieve(
  CUserAuth*  Caller,
  ObjectType  objectType,
  String*  QueryXML



Specifies the identity of the caller. The caller must have the prvCreateQuery and prvReadQuery privileges to perform this action. See CUserAuth.


Specifies the type of object that is to be queried. See CObjectName.


Specifies an XML string representing the query. The XML schema is described by savedquery.xsd.

Return Value

Returns a String type that specifies the XML data representing the new query. The XML schema is described by savedquery.xsd.


If there is an error, SOAP throws an exception and the error message is reported in System.Web.Services.Protocols.SoapException.Detail.OuterXml.

All IDs passed to the platform are GUIDs wrapped in braces. For example: {6522D89A-A752-4455-A2B0-51494C6957C3}


// strServer should be set with the name of the platform Web server
string strServer = "mystrServername";

// virtualDirectory should be set with the name of the Microsoft CRM
// virtual directory on the platform Web server
string virtualDirectory = "mscrmservices";
string strDir = "https://" + strServer + "/" + virtualDirectory + "/";

// BizUser proxy object
Microsoft.CRM.Proxy.BizUser bizUser = new Microsoft.CRM.Proxy.BizUser ();
bizUser.Credentials = System.Net.CredentialCache.DefaultCredentials;
bizUser.Url = strDir + "BizUser.srf";

// CRMQuery proxy object
Microsoft.CRM.Proxy.CRMQuery query = new Microsoft.CRM.Proxy.CRMQuery();
query.Credentials = System.Net.CredentialCache.DefaultCredentials;
query.Url = strDir + "CRMQuery.srf";

string strErrorMsg;
string strQueryXml;

   Microsoft.CRM.Proxy.CUserAuth userAuth = bizUser.WhoAmI();

   // Set up the XML string for the query
   strQueryXml = "<savedquery>";
   strQueryXml += "<description>Account query</description>";
   strQueryXml += "<name>Account Query 3</name>";
   strQueryXml += "<isquickfindquery>1</isquickfindquery>";
   strQueryXml += "<iscustomizable>1</iscustomizable>";
   strQueryXml += "<returnedtypecode>1</returnedtypecode>";
   strQueryXml += "<isdefault>1</isdefault>";
   strQueryXml += "<querytype>" + Microsoft.CRM.Flags.SAVED_QUERY_TYPE.ADVANCED_SEARCH.ToString() + "</querytype>";
   strQueryXml += "</savedquery>";

   // Create the query, and the retrieve it
   string strResultsXml = query.CreateAndRetrieve(userAuth, Microsoft.CRM.Proxy.ObjectType.otAccount, strQueryXml);

catch (System.Web.Services.Protocols.SoapException err)
   // Process the platform error here
   strErrorMsg = ("ErrorMessage: " + err.Message + " " + err.Detail.OuterXml + " Source: " + err.Source );
catch (Exception err)
   // Process other errors here
   strErrorMsg = ("ErrorMessage: " + err.Message );


Namespace: Microsoft.CRM.Proxy

Assembly: microsoft.crm.proxy.dll

See Also

© 2003 Microsoft Corporation. All rights reserved.