Query Audit Trail

API Type

Web Services

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

NameDescription

where

Function:
The where clause of the SQL statement you want to query.
Type
string
Accepted Values:
The where clause of a SQL statement.

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

Code Examples in the AgilePoint NX Documentation

The AgilePoint NX Product Documentation is intended as a basic reference to help you understand how to complete basic coding tasks, such as make API or JavaScript method calls. Code examples that show specific use cases, the solutions to specific business problems, or detailed implementation scenarios are outside the scope of the AgilePoint NX Product Documentation. For specific and/or advanced types of examples that may better meet your requirements, AgilePoint provides several resources:

  • AgilePoint Community Forums - A free, AgilePoint-moderated, crowd-sourcing user forum where you can ask questions about specific techniques, the solutions to use cases, workarounds, or other topics that may not be covered in the Product Documentation.
  • Professional Services - If you can not find the information you need for your specific business problem, mentoring is available through AgilePoint Professional Services.
  • Personalized Training - AgilePoint can provide personalized training for your organization. To request personalized training, contact AgilePoint Sales.