CRMQuery.Create Method
The Create method creates a new query.
Syntax
[Visual Basic .NET]
Public Function Create(
ByVal Caller As CUserAuth,
ByVal objectType As ObjectType,
ByVal QueryXML As String
) As String
[C#]
public string Create(
CUserAuth Caller,
ObjectType objectType,
string QueryXML
);
[C++]
public: String* Create(
CUserAuth* Caller,
ObjectType objectType,
String* QueryXML
);
Parameters
Caller
Specifies the identity of the caller. The caller must have the prvCreateQuery privilege to perform this action. See CUserAuth.
ObjectType
Specifies the type of object that is to be queried. See CObjectName.
QueryXML
Specifies an XML string representing the query. The XML schema is described by savedquery.xsd.
Return Value
Returns a String type that specifies the ID of the newly created query.
Remarks
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}
Example
[C#]
// 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;
string strQueryId;
try
{
Microsoft.CRM.Proxy.CUserAuth userAuth = bizUser.WhoAmI();
// Set up the XML string for the query
strQueryXml = "<savedquery>";
strQueryXml += "<description>Account query</description>";
strQueryXml += "<name>My Account 1</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
strQueryId = query.Create(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 );
}
Requirements
Namespace: Microsoft.CRM.Proxy
Assembly: microsoft.crm.proxy.dll
See Also