Add a New Database Lookup

Add a Database Lookup to use the result set in the lookup.

To add a Database Lookup

1. In the Enterprise Console, click menu icon, click Settings, and then click Lookup Settings. The Lookup Settings page appears.

2. Click New, and then click Database. The New Database Lookup dialog box appears.

3. In the Title box, type a name for the database lookup, and in the Description box, type a description for the database lookup.

4. Do one of the following:

   Task	Action
   Design the database lookup using a query.	In the Command Type list, click Query, and then click Continue. The New Database Lookup dialog box appears with additional options. Follow the steps for Add a New Database Lookup Using Query.
   Design the database lookup using a stored procedure.	In the Command Type list, click Stored Procedure, and then click Continue. The New Database Lookup dialog box appears with additional options. Follow the steps for Add a New Database Lookup Using Stored Procedure.

Note: Lookup title cannot have special characters and blank space. The only allowed special character is _ (underscore). Also, the Title starting with _SYS_ is not allowed.

Default Search Behaviour of Database Lookups

The default search behaviour of database lookups is to include the Display Value column and the Value column. If there is only a single Value column, then that Value column is considered, otherwise the first column returned from the results of the select query is considered provided that column is part of the Value column.

For example, If the Display Value is EmpDetails, the Value column contains multiple columns – Emp.Address, Emp.Name, and Emp.Age, and the select query is SELECT * from Emp; then EmpDetails from the Display Value column and Emp.Name from the Value column is considered for the search as the Emp.Name column is the first column in the database table.