Auto-Lookup > AgilePoint NX Data Entities > Multiple Columns

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 type of lookup procedure to do.

Accepted 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

Entity

Function:

Specifies the name for your entity.

Accepted 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?

Show Custom Entities

Function:

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

Accepted Values:

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

Default Value:

Deselected

Columns - Name

Function:

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.
2. On the Select All field, click Expand .

Accepted Values:

Read only.

The values are completed when you select the entity name.

Columns - Value

Function:

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.
2. On the Select All field, click Expand .

Accepted 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.

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 Filter

Function:

Adds a row to configure a condition for the filter.

To Open this Field:

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

Select Nest Type

Function:

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

To Open this Field:

1. Click Add Filter

Accepted Values:

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

Default Value:

And

Column Name

Function:

Specifies the name of the entity column.

To Open this Field:

1. Click Add Filter

Accepted Values:

A valid entity 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:

• !=
• =
• >
• <
• >=
• <=
• Like
• Not Like
• Contains
• Does Not Contain
• Begins With
• Does Not Begin With
• Ends With
• Does Not End With

Default Value:

=

Limitations:

The Contains and Does not Contain filter operators are available in these releases:

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

Filter Condition - Value

Function:

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

To Open this Field:

1. Click Add Filter

Accepted Values:

A process data variable.

Default Value:

None

Accepts Process Data Variables:

Yes

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

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.