Update Record activity

Display Name

Function:

Specifies the activity name that shows in your process.

Accepted Values:

One line of text that can have spaces.

Default Value:

None

Accepts Process Data Variables:

No

Description

Function:

Specifies an optional description for your activity.

Accepted Values:

More than one line of text.

Default Value:

None

Accepts Process Data Variables:

No

Database Type

Function:

Specifies the type of database to be used.

Accepted Values:

• SQL Server
• Oracle

Default Value:

SQL Server

Connection Timeout (Seconds)

Function:

Specifies the number of seconds permitted to complete an action before the connection stops.

Accepted Values:

An integer that represents a number of seconds.

Default Value:

600

Accepts Process Data Variables:

No

Database

Function:

Specifies the access token that connects to your database.

Accepted Values:

A list of access tokens configured for your environment.

Default Value:

None

Accepts Process Data Variables:

No

Add Token

Opens this Screen:

New Database Access Token

Function of this Screen:

Configures a new access token for a database.

Table Name

Function:

Specifies the name of the database table where this activity puts the record.

Accepted Values:

A valid database table name.

Default Value:

None

Accepts Process Data Variables:

Yes

Example:

Condition (SQL Formula)

Function:

The SQL WHERE clause that tells which database records to change.

Accepted Values:

A valid SQL WHERE clause.

Default Value:

None

Accepts Process Data Variables:

No

Example:

InvoiceNumber <= 3452

Column Name

Function:

Specifies the name of the database column.

Accepted Values:

A valid database column name.

Default Value:

None

Accepts Process Data Variables:

No

Example:

CustomerName

Filter

Function:

Shows the items in the list based on the values you enter.

1. Click Filter .
2. On the filter screen, select your operator.
3. Enter the values to show in your list.

Accepted Values:

• Is equal to
• Is not equal to
• Starts with
• Contains
• Does not contain
• Ends with

Default Value:

Is equal to

Column Value

Function:

Specifies an XPath to a single node within the given repeating XPath.

Accepted Values:

A valid XPath.

Default Value:

None

Accepts Process Data Variables:

Yes

Example:

${/pd:AgilePoint/pd:Products/pd:ComponentName}

Create

Function:

Creates a row to add a process data variable, value, and event.

Delete

Function:

Deletes the selected item.