User Defined Columns in Runtime Views

Predefined column types are provided for runtime views to be added as user defined column tables. If column types are provided, they could be one or more of the following:

Process Data

To join process data to the runtime view:

  1. Select Process Data in the User Defined Columns section.
  2. Click Add.

A new menu item Process DataXX will become available in the Column Type section. Select this item and click Edit.

The Additional Process Data Column dialog opens, where you can change the column name and specify the process data to be joined:

Click OK to save the changes in the dialog. In addition to the new output column, a new parameter will be created. This parameter can be used to specify an expression the result set will be filtered by.

Adding Structured Data

When selecting a data of type structured data, you can choose elements of the structured data in the Additional Process Data Column dialog:

Activity Metrics

For each activity metric defined an output column displaying the time difference between two activities is added to the runtime view. To create an activity metric:

  1. Select Activity Metrics in the User Defined Columns section.
  2. Click Add.

Select the newly created tree item ActivityMetricsXX and click Edit.

In the Additional Column with Activity Metrics dialog, specify the following settings:

Click OK to save the changes. In addition to the new output column, a new parameter will be created. This parameter can be used to specify an expression the result set will be filtered by.

Foreign Data

A foreign data table column is not part of your Stardust Process model but part of a non-Stardust data table. Such columns can be joined to a runtime view, if the table is retrievable from the same data source (same database connection and user account) as the view itself. A foreign data table column will be joined on a process data column, which has to be defined in advance (ProcessData13 in the screenshot). To join a foreign data table column:

  1. Select Foreign Data in the User Defined Columns section.
  2. Click Add.

Select the newly created tree item ForeignDataXX and click Edit.

In the Additional Foreign Data Column dialog, specify the following settings:

Click OK to save the changes. In addition to the new output column, a new parameter will be created. This parameter can be used to specify an expression the result set will be filtered by.

Model Property

To join additional data to your runtime view:

  1. Select Model Property in the User Defined Columns section.
  2. Click Add.

Select the newly created tree item ModelPropertyXX and click Edit.

A dialog opens where you can enter the following attributes for the additional data column:

In case the attribute name entered as property path is not correct, the entries in the result set remain empty.

Optional data columns

To add optional data columns to the runtime view:

  1. Select Optional data columns in the User Defined Columns section.
  2. Click Add.

A dialog opens, where you can choose a process id. Momentarily only the StartingProcessID, returning the process ID of the starting process, is provided.