Query Process Instances (Extended Method)

// Console application sample code to illustrate QueryProcInstsEx API.
IWFWorkflowService svc = GetWorkflowService();

// SQL Expression
string where = "STATUS in ('Running','Canceled')";

try
	{
    //Calling QueryProcInstsEx WebMethod with sql query expression as argument.
    WFBaseProcessInstance[] result = svc.QueryProcInstsEx(where);
    
    if (result != null)
        {
        // Iterating through the list of the Process Instance
        foreach (WFBaseProcessInstance processInstance in result
            {
            //Displaying the Process Instance Details on Console.
            Console.WriteLine("ApplName-->" + processInstance.ApplName
            Console.WriteLine("DefName-->" + processInstance.DefName);
            Console.WriteLine("DefID-->" + processInstance.DefID);
            Console.WriteLine("CompletedDate-->" +
            processInstance.CompletedDate);
            Console.WriteLine("LastModifiedBy-->" +
            processInstance.LastModifiedBy);
            }
        }
	}

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