Database Insert Configuration Window

Description

Definition:

A free text description of the event.

Allowed Values:

Multiple lines of text.

Default Value:

None.

Custom Attributes:

No

Connection String

Definition:

Specifies the database connection string to be used to connect to the database at runtime.

Allowed Values:

Multiple lines of text.

Default Value:

None

Custom Attributes:

No

Choose

Opens the Following Window:

Browse Shared Custom Attributes

Purpose of this Window:

Enables you to choose a connection string from the list of global custom attributes in the in the format of a database connection string. Select the connection string you want, and click OK.

Build Connection String

Opens the Following Window:

Connection String Builder Window

Purpose of this Window:

Creates a connection string to connect AgilePoint Event Services and a database.

Table Name

Definition:

Specifies the name of the database table you want.

Allowed Values:

The name of your table.

If you select the Enter Table Name check box, the Table Name list becomes unavailable to select a table name. Type a table name in the box.

Default Value:

None

Enter Table Name

Definition:

Specifies that you want to enter a custom database table name in the Table Name field.

Allowed Values:

• Deselected - The Table Name field is not editable.
• Selected - The Table Name field allows a custom table name to be entered.

Default Value:

Deselected

Primary Key

Definition:

Specifies the primary key for the database table.

Allowed Values:

The name of your primary key.

If you select the Enter primary key check box, the Primary Key list becomes unavailable to select a primary key. Type a primary key in the box.

Default Value:

None

Enter Primary Key

Definition:

Allows to type a primary key in the Primary Key box.

Allowed Values:

• Deselected - Specifies to select a primary key from the Primary Key list.
• Selected - Specifies to type a primary key in the Primary Key box.

Default Value:

Deselected

Query Frequency

Definition:

Specifies the query frequency in minutes.

Allowed Values:

An integer.

Default Value:

None

Custom Attributes:

No

Field Name

Definition:

Specifies the database column name you want.

Allowed Values:

The name of your database column name.

Default Value:

None

Custom Attributes:

No

Data Bind

Definition:

Specifies a custom attribute as a data field to be assigned to the database column's data.

Allowed Values:

A custom attribute.

Default Value:

None

Add

Function:

Assigns the specified custom attribute to the database column's data and displays the values in a tabular format.

Process Template

Definition:

Specifies the name of the process model to be triggered to create a process instance when database insert event occurs.

Allowed Values:

The name of your process model.

Default Value:

None

Default Process Instance Prefix

Definition:

Specifies the prefix to be added to the process instance name that is created when database insert event occurs.

Allowed Values:

A text string.

If you select the Select Column Data check box, a list is available to select a data column. The selected data column's value is added as a prefix to the process instance name.

Default Value:

None

Custom Attributes:

No

Select Column Data

Definition:

Specifies that you want to use the data column's value of the newly inserted record as a process instance prefix.

Allowed Values:

• Deselected - The Default Process Instance Prefix field is editable. Enter the text you want to be added as a prefix to the process instance name.
• Selected - The Default Process Instance Prefix field allows to select a data column. The selected data column's value is added as a prefix to the process instance name.

Default Value:

Deselected

Enable this schedule

Definition:

Determines whether the database insert trigger is to be activated.

Allowed Values:

• Deselected - Deactivates the database insert trigger.
• Selected - Activates the database insert trigger.

Default Value:

Deselected