Add a New Repository List Lookup

This section provides detailed procedures for creating a new Repository List lookup.

To add a new Repository List lookup

1. In the Enterprise Console, click the Menu button, click Settings, and then click Lookup Settings. The Lookup Settings page appears.

2. Click the New Lookup List icon on the Ribbon Bar. The New Repository List Lookup dialog box appears.

   Field	Description
   Lookup Name	Enter the appropriate title for the lookup.
   Description	Enter the appropriate description for the lookup.
   List Name	Select the List name to be associated with the lookup.
   Get all records	Select the required option. Select True, if you would like to display all the records from the list. Select False, if you would like to display only selected records from the list. When you select False, the List Query field is displayed below this field.
   List Query	Click the Query button to build a filter query to get the required records. This field is enabled only if the Get all records option is selected as "False". Query can be built using Value, Parameter or Table Fields. For more information on building a List Query, see Add a List Query.
   Order By Query	Click the Query button to build a query to sort the list items based on the given condition (Similar to Order by clause of the sql queries). Data can be either in ascending or descending order.  For more information on building a Order By Query, see Add an Order By Query.
   Table	Click this text box to select the required table. The tables that are associated to a List are displayed in a tree menu as shown below. The tree menu displays the hierarchy of tables.
   Available Columns	This field displays all the columns associated to the selected table.
   Selected Columns	This field displays all the selected columns of the selected table. You can select or deselect the columns.
   Display Column	This field displays the column to be displayed in the lookup. For example, Employee Name column.
   Value	Select the required option. The options are Auto, Custom.  If Auto option is selected, the Id column of the table selected is considered as value field. For Example, for an Employee list, the Employee Name will be display column and Employee ID will be Value column. If Custom option is selected, you can specify the desired value column. Note: The column specified in the Value field should identify a unique row in the table.
   Display value column in grid	Select the required option. The options are Yes, No.  If Yes option is selected, the selected value column is displayed in the lookup. If No option is selected, the selected value column is not displayed in the lookup.
   Form	This field does not support any functionality for the current release.

   Note: 
   - The column "Title" will always be a part of the Available Columns and Display Column fields. The "Title" column should not be selected if it is not a part of the List Definition.
   - The Title of repository list lookups cannot have special characters and blank space. The only allowed special character is _ (underscore). Also, the Title starting with _SYS_ is not allowed.

3. Type the lookup name in the Lookup Name field and enter its description in the Description field.

4. Select the List name, and then select the required columns.

5. Click Update.

Please note the following important things about the Dynamic Query Builder.

The following operators are available for creating queries using the Dynamic Query Builder:

• =

• >

• <

• >=

• <=

• <>

• IN

• Not In

• Like

• Is Null

• Is Not Null

Queries cannot have any Special Characters except '@' for Parameter Name.