Configure Lookup for AgilePoint Data Entities > Multiple Columns

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

Select Column - Name

Function:

Specifies the column names for the selected entity.

To Open this Field:

1. On the Configure Lookup screen, in the Request tab, select the name of the method from the Service Operation list
2. On the Select All field, click Expand .

Accepted Values:

Read only.

The values are completed when you select the entity name.

Select Column - Value

Function:

Specifies the value to update for the column.

To Open this Field:

1. On the Configure Lookup screen, in the Request tab, select the name of the method from the Service Operation list
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 give 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 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 PrivateCloud 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 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.