Auto-Lookup > AgilePoint NX Data Entities > Multiple Columns
This topic shows how to create a lookup with Data Entities as the data source based on multiple columns for the Auto-Lookup form control.
Background and Setup
Prerequisites
- AgilePoint NX OnDemand (public cloud), or AgilePoint NX PrivateCloud or AgilePoint NX OnPremises v7.0 or higher.
Good to Know
- It is not necessary to create an access token to use Data Entities in a lookup.
- There is more than one path to configure a lookup. Make sure you use the document that shows the path for your lookup.
How to Start
- On the Auto-Lookup form control configuration screen, on the Configure tab,
click Add Lookup.
For information about how to open this screen, refer to Auto-Lookup form control.
- On the Select Data Source Type screen,
select
Data Entities.
- Click Next.
Lookup Details
Specifies the basic configuration for a lookup.

Good to Know
- There is more than one path to configure a lookup. Make sure you use the document that shows the path for your lookup.
Fields
Field Name | Definition |
---|---|
Lookup Name |
|
Lookup Type |
|
Configure Lookup > Quick Config tab
Configures a lookup with more than one column from your data source.

Fields
Field Name | Definition |
---|---|
Show Custom Entities |
|
Entity |
|
Source Column | |
App Variable |
|
Display Name |
|
Expand |
|
Collapse |
|
Add expression |
|
Add group |
|
Select Nest Type | |
Column Name | |
Operator |
|
Value |
|
Delete | |
Sort By |
|
Sort Order |
|
Configure Lookup > Advanced tab
Configures a WHERE clause for your query.

Prerequisites
- AgilePoint NX OnDemand (public cloud), or AgilePoint NX PrivateCloud or AgilePoint NX OnPremises v9.0 Software Update 1 or higher.
Fields
Field Name | Definition |
---|---|
Query |
|
Perform SQL Query Escaping |
|
Validate Query |
|
Result |
|
Configure Columns |
|
Configure Lookup > Configure Columns
Configures a data type for more than one column to show in your lookup.

Prerequisites
- AgilePoint NX OnDemand (public cloud), or AgilePoint NX PrivateCloud or AgilePoint NX OnPremises v9.0 Software Update 1 or higher.
Fields
Field Name | Definition |
---|---|
Display Name |
|
Data Type |
|
Format |
|
Format |
|
Reset |
|
Collapse All |
|
Configure Lookup > Error Messages tab
Configures the message to show if the lookup does not return any data.

Fields
Field Name | Definition |
---|---|
No Items Retrieved |
|
Lookup Failed |
|