Query Archived Process Instances

Description

Retrieves process instances that match a SQL query.

Syntax

public virtual WFBaseProcessInstance[] QueryArchivedProcInsts(string sql)

Parameters

Name	Type	Description
sql	string	A string that contains the where clause of the SQL statement you want to query.

Output

An array of WFBaseProcessInstance objects.

Example

// Build SQL Statement
string processDefinitionName = "Budget Request Approval Process";
string sqlWhereClause = string.Format("DEF_NAME ='{0}'",
processDefinitionName);

try
	{
    WFBaseProcessInstance[] archivedProcessInstances =
    svc.QueryArchivedProcInsts(sqlWhereClause)
	}

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

Supported Versions

3.2.0.4 and higher

Parent topic: Methods for Archiving and Restoring Processes