Query Audit Trail

Description

Retrieves all audit trail items using a a specified WHERE clause of an SQL query expression.

Good to Know

• Only pass the WHERE clause without WHERE keyword, not the whole query.

Syntax

public virtual WFAuditTrailItem[] QueryAuditTrail(string where)

Parameters

Output

An array list of WFAuditTrailItem objects.

Example

// This is console application sample
IWFWorkflowService svc = GetWorkflowService();

// Checking where condition based on the CATEGORY COLUMNand PURPOSE
COLUMN .
string where = "CATEGORY = 0 AND PURPOSE='Check-in process
definition'";

try
	{
    // calling the QueryAuditTrail web method it return a array of Dataset.
    WFAuditTrailItem[] result = svc.QueryAuditTrail(where);
    foreach (WFAuditTrailItem item in result)// Iterating through
    WFAuditTrailItem
	   { 
        //Displaying the result on the console.
        System.Console.Write("ItemCategory: {0} ,ItemDateOccurred: {1}",
                    item.Category,item.DateOccurred);
        System.Console.Write("ItemDescription: {0} ,ItemObjectID: {1}",
                    item.Description, item.ObjectID);
        System.Console.WriteLine("ItemPurpose: {0} ,ItemPerformer: {1}",
                    item.Purpose item.Performer);
        }
	}

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

Supported Versions

4.0.1 and higher