Query Database (Extended Method)

API Type

Web Services

Description

Queries the database with any valid SQL query and returns an array of 2 elements in XML string format.

Syntax

public virtual string[] QueryDatabaseEx(string sql)

Parameters

Name	Description
sql	Definition: The where clause of the SQL statement you want to query. Type string Allowed Values: The where clause of a SQL statement.

Output

2 elements in a string array, where string[0] is an XML string with the dataset of the query results and string[1] is an XML string with the schema.

Example

IWFWorkflowService svc = GetWorkflowService();
string sql = "SELECT * FROM WF_AUDIT_TRAILS where CATEGORY = 0 AND
PURPOSE='Check-in process definition'";

try
	{
    // calling the QueryDatabase web method and passing the sql query as the argument.
    string[] xmls = svc.QueryDatabase(sql);
    Console.WriteLine("{0}", xmls[0]);// Displaying the XML string on console.
    Console.WriteLine("{0}", xmls[1]);// Displaying the schema on console.
	}

catch (Exception ex)
	{
    Console.WriteLine("Failed! " + ShUtil.GetSoapMessage(ex));
	}

Supported Versions

3.2.0.4 and higher