Specifying Data Sources

The first step in defining a Report is to specify the data source or sources that the data should be retrieved from.

Data is pulled from the Audit Trail database and may be computed.

Data Source tab
Figure: Data Source tab

Retrieving Audit Trail Data

You have the option to retrieve audit trail data about process instances and activity instances.

Retrieving Data about
Figure: Retrieving Data about

The following table displays the data that can be retrieved for process instances and for activity instances accordingly.

Selection Process Instances Activity Instances
Process Instance OID X X
Process ID X X
Process Name X X
Root Process Start Time X X
Process Start Time X X
Process Termination Date X
Starting User Name X
Process State X
Priority X
Descriptors
(of the supported data types listed in section
Supported Data Types of chapter Specifying Data Sets)
X X
Activity Instance OID X
Activity ID X
Activity Name X
Start Time X
Last Modification X
User Performer X
Role/Org Performer X
Activity State X
Criticality X

Computed Columns

You can add additional computed columns to the records from Audit Trail Data by providing a JavaScript expression to calculate corresponding data.

To add a computed column do the following:

  1. Click the Add icon

    Add computed column

  2. Enter a field name and the name the field should be displayed as in the table
  3. Select a type in the Type field

    Select Type

  4. Now enter JavaScript code to compute the column

For example to calculate a ProcessNameOID column to combine the process name and OID in one column, you can provide the following expression:

processName + " " + processOID

The computed column would look like the following in the preview:

You can also add more complex expressions, e.g. for calculating a Duration via:

var from = new Data(startTimeStamp);
var to = new Date(lastModificationTimeStamp);
(to.getTime() - from.getTime()) / 1000 / 60 / 60; // Returns duration in hours

Note that in the last example we even have done some variable definitions and calculations up front. Only the final expression computes the value for the computed column. You can even define functions above the return expression., e.g.:

function createDurationString(from, to)
{
}
createDurationString(startTimestamp, lastModificationTimestamp)

Code completion is provided by clicking Ctrl - Space.