Configure Lookup for Database > Name/Value

Schema

Function:

Specifies your database schema.

Accepted Values:

A schema name from the list.

When you select a database, the schemas associated with the database show in this field.

Default Value:

None

Table

Function:

Specifies the name of the your database table.

Accepted Values:

The name of your table.

When you select a schema, the tables associated with the database show in this field.

Default Value:

None

Name

Function:

Specifies the column name of the database table in a key-value pair.

To Open this Field:

1. Select a table from the Table list.

Accepted Values:

The column name from the list.

When you select a database table, the columns and its values associated with the database table show in this field.

Default Value:

None

Value

Function:

Specifies the value for a database column in a key-value pair.

To Open this Field:

1. Select a table from the Table list.

Accepted Values:

The value from the list.

When you select a database table, the columns and its values associated with the database table show in this field.

Default Value:

None

Column Name

Function:

Specifies the name of the database column.

To Open this Field:

1. Click Add Filter

Accepted Values:

A valid database column name.

Default Value:

None

Operator

Function:

Specifies the operator to use in filter.

To Open this Field:

1. Click Add Filter

Accepted Values:

• In
• !=
• =
• >
• <

Default Value:

=

Limitations:

The In operator is available in these releases:

• AgilePoint NX OnDemand (public cloud)
• AgilePoint NX PrivateCloud or AgilePoint NX OnPremises v7.0 Software Update 2 or higher

Filter Condition - Value

Function:

Specifies one or more values for the column or process data variables that contains the column value.

To Open this Field:

1. Click Add Filter

Accepted Values:

One or more column values.

Default Value:

None

Accepts Process Data Variables:

Yes

Limitations:

The option to use more than one value is available in these releases:

• AgilePoint NX OnDemand (public cloud)
• AgilePoint NX PrivateCloud or AgilePoint NX OnPremises v7.0 Software Update 2 or higher

Delete Filter

Function:

Deletes the filter condition.

Filter Condition - Sort By

Function:

Specifies the name of the column to sequence the query results.

Accepted Values:

The name of your list column.

Default Value:

None

Filter Condition - Sort Order

Function:

Specifies the sort order for the result set.

Accepted Values:

• Ascending
• Descending

Default Value:

Ascending

Query

Function:

Specifies the WHERE clause for your query with the conditions and logical operators

Accepted Values:

• A valid SQL WHERE clause.
• A valid stored procedure.
• A valid SQL view.

Default Value:

None

Example:

SELECT PositionCode, FirstName, LastName, Email, City, StateCode, ZipCode FROM [appApplicants] WHERE PositionCode = ${PositionCode}

Perform SQL Query Escaping

Function:

Specifies whether the query condition value escapes the apostrophe (') character.

Accepted Values:

• Selected - Apostrophe (') characters are escaped in your query condition value.
• Deselected - The query condition value does not escape apostrophe (') characters.

Default Value:

Selected

Example:

SELECT PositionCode, FirstName, LastName, Email, City, StateCode, ZipCode FROM [appApplicants] WHERE PositionCode = ${PositionCode}

Limitations:

• AgilePoint NX OnDemand (public cloud), or AgilePoint NX PrivateCloud or AgilePoint NX OnPremises v7.0 or higher.

Validate Query

Function:

Does a test to make sure the query is correct, and displays the error message if an error occurs.

Result

Function:

Shows the result of the WHERE clause query.

No Items Available

Function:

Specifies the error message to show if the lookup does not return any data.

Accepted Values:

One line of text that can have spaces.

Default Value:

None

Failure Messages

Function:

Specifies the message to show if the data fails to load.

Accepted Values:

More than one line of text.

Default Value:

Failed to load data.