Lookups are metadata which enable the application to provide lists of business descriptions to users when building filter criteria on columns containing only code values. Lookups make the process of creating filter criteria much easier so it is recommended that you set them up before creating rules, although they can be added at any time.
For example, Lookups could be set up to provide lists of Product Descriptions, Transaction Types, Customer Demographics, Countries, or other Geographic regions.
-
Select
> Configuration > Lookups.
-
Do one of the following:
Option Steps Create a lookup - Click CREATE NEW .
- Select a database Connection.
- Select a Source database, Source table, and Source column. Use this column in your Filter criteria, which should contain the code values for which the Lookup provides descriptions.
- Select a Lookup database and Lookup table.
This table is the Lookup table, which may be a Table or View.
These fields must be populated before the remaining Lookup fields are enabled.
- Select the Lookup ID column, Lookup description column, Lookup sort column, Lookup filter column, and Lookup filter value. These details specify the columns in the Lookup table that will be used.
- Click CREATE NEW LOOKUP LIST.
Update a lookup - Select
> Edit.Click
to search for a lookup item. - Modify the Connection, Source fields, or Lookup fields.
- Click SAVE LOOKUP LIST.
Delete a lookup - Select
> Delete. - Click DELETE to confirm the deletion.