Single Select Lookup > Database

Access Token

Function:

Specifies the access token that connects to your data source.

Accepted Values:

A list of access tokens configured for your environment.

Default Value:

None

Accepts Process Data Variables:

No

Add New

Opens this Screen:

Access Token for Database

Function of this Screen:

Configure an access token to connect to a database.

Lookup Name

Function:

Specifies the name you want to give to your lookup procedure.

Accepted Values:

One line of text that can have spaces.

Default Value:

None

Accepts Process Data Variables:

No

Example:

Refer to:

• (Example) How Do I Configure a Pop-Up Select Control to Bind the Lookup Values to a Data Grid?
• (Example) Configure an Auto-Lookup Form Control with Microsoft Excel

Lookup Type

Function:

Specifies the Name/Value type for the lookup procedure.

The Single Select Lookup form control does not support Multiple Columns lookups. If you select the Multiple Columns, the configuration screen shows Name/Value lookup type.

Accepted Values:

Read only.

Default Value:

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

Columns - 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:

A 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

Columns - 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:

A column 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 the filter.

To Open this Field:

1. Click Add Filter

Accepted Values:

• =
• !=
• >
• <
• In
• Is Null
• Is Not Null

Default Value:

=

Limitations:

• The In operator is available in these releases:

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

• The Is Null and Is Not Null options are available in these releases:

  • AgilePoint NX OnDemand (public cloud)
  • AgilePoint NX Private Cloud or AgilePoint NX OnPremises v8.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 Private Cloud 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 [Account Owner] "Name", [Account Number] "Value" FROM Account
• 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 [Account Owner] "Name", [Account Number] "Value" FROM Account
• SELECT PositionCode, FirstName, LastName, Email, City, StateCode, ZipCode FROM [appApplicants] WHERE PositionCode = ${PositionCode}

Limitations:

• AgilePoint NX OnDemand (public cloud), or AgilePoint NX Private Cloud 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 Retrieved

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

Lookup Failed

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.