You can set up a configurable lookup to define the possible options in a field.
You can define the possible options for a configurable lookup in these ways:
To apply a configurable lookup, set up a validation rule of type Configurable lookup. You can use a configurable lookup on several validation rules.
This topic explains how to set up a configurable lookup.
Name | Responsible | Description |
---|---|---|
Set up configurable lookup - User defined list |
Data quality administrator |
You can set up a configurable lookup of type 'User defined list' to manually define the possible options in a field. |
Set up dynamic query |
Data quality administrator |
Use a dynamic query to find one or more records in the database. The found records are the input for further processing. You can use a dynamic query on:
To define a query range, you can use a function. |
Set up configurable lookup - Dynamic query |
Data quality administrator |
You can set up a configurable lookup of type 'Dynamic query' to define the possible options in a field with a dynamic query. |