Auto-Lookup > AgilePoint NX Data Entities > Multiple Columns

Lookup Name

Description:

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

Allowed Values:

One line of text (a string).

Accepted:

• Letters
• Numbers
• Spaces

Default Value:

None

Accepts 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

Description:

Specifies the type of lookup procedure to do.

Allowed Values:

• Name/Value - The lookup gets data for specified name/value pairs.
• Multiple Columns - The lookup gets data for more than one column.

Default Value:

Name/Value

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

Show Custom Entities

Description:

Specifies whether to show only custom entities in the Select Entity list.

Allowed Values:

• Selected - Shows only custom entities in the Select Entity list.
• Deselected - Shows only standard entities in the Select Entity list.

Default Value:

Deselected

Entity

Description:

Specifies the name for your entity.

Allowed Values:

The name of your entity.

Default Value:

None

Example:

Refer to:

• (Example) How Do I Configure a Pop-Up Select Control to Bind the Lookup Values to a Data Grid?

Source Column

Description:

Shows the column names for the selected entity.

To Open this Field:

1. On the Configure Lookup screen, in the Entity list, select an entity.

Allowed Values:

Read only.

The values are completed when you select the entity name.

App Variable

Description:

Specifies the value to update for the column.

To Open this Field:

1. On the Configure Lookup screen, in the Entity list, select an entity.

Allowed Values:

None.

But when you add a column in the list, the value field is populated with the column's name. Set the actual value.

Display Name

Description:

Specifies the name for the column that shows in your lookup.

To Open this Field:

1. On the Configure Lookup screen, in the Entity list, select an entity.

Allowed Values:

One line of text (a string).

Accepted:

• Letters
• Numbers
• Spaces
• Special characters

Default Value:

None

Limitations:

This field is available in these releases:

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

Expand

Function:

Shows the field list options.

To Open this Field:

1. On the Configure Lookup screen, in the Entity list, select an entity.

Collapse

Function:

Closes the field list.

To Open this Field:

1. On the Configure Lookup screen, in the Entity list, select an entity.

Add expression

Function:

Creates a condition row.

To Open this Field:

1. On the Configure Lookup screen, in the Entity list, select an entity.

Limitations:

This field is available in these releases:

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

Add group

Function:

Creates a new conditional expression group.

To Open this Field:

1. On the Configure Lookup screen, in the Entity list, select an entity.

Limitations:

This field is available in these releases:

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

Select Nest Type

Description:

Specifies the AND and OR logical operators to filter the lookup.

To Open this Field:

1. On the Configure Lookup screen, in the Entity list, select an entity.

Allowed Values:

• AND - Specifies the AND operator.
• OR - Specifies the OR operator.

Default Value:

And

Column Name

Description:

Specifies the name of the entity column.

To Open this Field:

1. On the Configure Lookup screen, in the Entity list, select an entity.
2. Click Add expression .

Allowed Values:

A column name from the list.

Default Value:

None

Operator

Description:

Specifies the operator to use in the filter.

To Open this Field:

1. On the Configure Lookup screen, in the Entity list, select an entity.
2. Click Add expression .

Allowed Values:

• !=
• =
• >
• <
• >=
• <=
• Like
• Not Like
• Contains
• Does Not Contain
• Begins with
• Does Not Begin With
• Ends With
• Does Not End With
• In
• Is Null
• Is Not Null

Default Value:

=

Limitations:

• The In operator is available in these releases:
  • AgilePoint NX OnDemand (public cloud)
  • AgilePoint NX PrivateCloud or AgilePoint NX OnPremises v9.0 Software Update 1 or higher
• The Is Null and Is Not Null options are available in these releases:
  • AgilePoint NX OnDemand (public cloud)
  • AgilePoint NX PrivateCloud or AgilePoint NX OnPremises v9.0 or higher
• The Contains and Does not Contain filter operators are available in these releases:
  • AgilePoint NX OnDemand (public cloud)
  • AgilePoint NX PrivateCloud or AgilePoint NX OnPremises v7.0 Software Update 2 or higher

Value

Description:

Specifies the value for an entity field to use in filter.

To Open this Field:

1. On the Configure Lookup screen, in the Entity list, select an entity.
2. Click Add expression .

Allowed Values:

One line of text (a string).

Accepted:

• Letters
• Numbers
• Spaces
• Special characters

Default Value:

None

Accepts Variables:

Yes

Delete

Function:

Deletes the condition row.

To Open this Field:

1. On the Configure Lookup screen, in the Entity list, select an entity.
2. Click Add expression .

Sort By

Description:

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

To Open this Field:

1. On the Configure Lookup screen, in the Entity list, select an entity.

Allowed Values:

A column name from the list.

Default Value:

None

Sort Order

Description:

Specifies the sort order for the result set.

To Open this Field:

1. On the Configure Lookup screen, in the Entity list, select an entity.

Allowed Values:

• Ascending
• Descending

Default Value:

Ascending

Query

Description:

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

Allowed 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

Description:

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

Allowed Values:

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

Default Value:

Deselected

Example:

• SELECT [Account Owner] "Name", [Account Number] "Value" FROM Account
• SELECT PositionCode, FirstName, LastName, Email, City, StateCode, ZipCode FROM [appApplicants] WHERE PositionCode = ${PositionCode}

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.

Configure Columns

Opens this Screen:

Configure Lookup > Configure Columns

Function:

Configures a data type for more than one column to show in your lookup.

Display Name

Description:

Specifies the name for the column that shows in your lookup.

Allowed Values:

One line of text (a string).

Accepted:

• Letters
• Numbers
• Spaces
• Special characters

Default Value:

Different for different columns

Data Type

Description:

Specifies the data type for the column.

Allowed Values:

A data type from the list.

Default Value:

None

Format

Description:

Specifies the date format that the column shows.

To Open this Field:

1. In the Data Type field, select Date.

Allowed Values:

• MM/dd/yyyy - Shows the date in the format Month/day/year.
• yyyy/MM/dd - Shows the date in the format year/Month/day.
• yyyy-MM-dd - Shows the date in the format year-Month-day.
• dd-MM-yyyy - Shows the date in the format day-Month-year.
• dd MMM yyyy - Shows the date in the format day Month year.
• MMM dd yyyy - Shows the date in the format Month day year.

Default Value:

None

Example:

• 09/21/1978
• 1978/09/21

Format

Description:

Specifies the date-time format that the column shows.

To Open this Field:

1. In the Data Type field, select DateTime.

Allowed Values:

• MM/dd/yyyy - Shows the date in the format Month/day/year.
• MM/dd/yyyy HH:mm:ss - Shows the date-time in the format Month/day/year hour:minute:second.
• yyyy/MM/dd - Shows the date in the format year/Month/day.
• yyyy-MM-dd HH:mm:ss - Shows the date-time in the format year-Month-day hour:minute:second.
• yyyy-MM-dd - Shows the date in the format year-Month-day.
• dd-MM-yyyy - Shows the date in the format day-Month-year.
• dd-MM-yyyy HH:mm:ss - Shows the date-time in the format day-Month-year hour:minute:second.
• dd MMM yyyy - Shows the date in the format day Month year.
• dd MMM yyyy HH:mm:ss - Shows the date-time in the format day Month year hour:minute:second.
• MMM dd yyyy - Shows the date in the format Month day year.
• MMM dd yyyy HH:mm:ss - Shows the date-time in the format Month day year hour:minute:second.

Default Value:

None

Example:

• 09/21/1978 18:35:50

Reset

Description:

Restores the default display name and data type for the column.

Collapse All

Description:

Specifies whether to close the Display Name and Data Type fields for all columns on the screen.

Allowed Values:

• On - Closes the Display Name and Data Type fields for all columns.
• Off - By default, the Display Name and Data Type fields stay open for all columns.

Default Value:

Deselected

No Items Retrieved

Description:

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

Allowed Values:

One line of text (a string).

Accepted:

• Letters
• Numbers
• Spaces

Default Value:

None

Lookup Failed

Description:

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

Allowed Values:

More than one line of text.

Default Value:

Failed to load data.