Siebel Applications Administration Guide > Working with Lists of Values >

Adding a New Value to an Existing List of Values

To add an item to an existing list of values so that it appears in a drop-down list, you must know its type. You can find out the type by querying the list-of-values list to determine the type associated with a specific display value. Then you can create a new record with that type. For example, in the Accounts list you can see the Status drop-down list. Also, you use this field to indicate ratings for your accounts' reliability. Initial settings are Gold and Silver. You might want to add another status of Bronze to this list, to give to customers who have a reliable account rating. The procedure in this topic uses this example.

The maximum number of values allowed for one LOV type is 10,000.

To identify the list-of-values type for a display value

1. Navigate to the screen displaying the drop-down list to which you want to add a value (for example, the Accounts screen).
2. Select the drop-down list and make note of one of the choices.

   For example, in the Accounts screen, select the Status drop-down list and make note of the value Gold.

   TIP:   Be sure to note the capitalization and spacing of the choice.

3. Navigate to the Administration - Data screen, then the List of Values view.
4. In the list-of-values list, perform a query in the Display Value field, using the value you note in Step 2.
5. In the list of records that is returned, identify the appropriate record by reviewing the entries in the Type field.

   List-of-values types usually have names that relate to the field labels in the screens where they are used. In this example, you look for a type labeled something like ACCOUNT_STATUS.

   When you create a new value for this list, you use this type.

Adding the New Value

Complete the following procedure to add a new value to an existing list of values.

To add a new value to an existing list of values

1. Navigate to the Administration - Data screen, then the List of Values view.
2. Create a new record, and complete the necessary fields.

   Some of the fields are described in the following table.

   Field	Comments
   Type	Select a type for the list of values. For example, select ACCOUNT_STATUS.
   Display Value	Type the new value for the list of values. For example, if Bronze is the status that your organization gives to customers who have a reliable account rating, and you want to make Bronze available as in the Account Status drop-down, then enter Bronze as the display value. Make sure that the length of the display value you enter does not exceed the allowed length of the destination column.
   Language Independent Code	Type the Language Independent Code for the list of values. This value is usually the same as the value in the Display Value field. Make sure that the length of the Language Independent Code you enter does not exceed the allowed length of the destination column. NOTE:  The Display Name field and Language Independent Code field must both be unique within a list-of-values type, except when configuring a multilingual list of values. If you add a value that already exists, then an error message appears. For example, there cannot be two ACCOUNT_STATUS records that have a display value of Bronze. For information about multilingual lists of values, see the definition of the Language Independent Code field in Table 11.
   Order	Type a number to indicate the numerical order in which the value appears in a drop-down list. For example, if the order numbers for Gold and Silver are 1 and 2, respectively, then the order number for Bronze is 3.

3. If appropriate, complete the remaining fields in the record.

   For a description of these fields, see List-of-Values Fields.

4. Clear the LOV cache by clicking Clear Cache.

   After you have cleared the cache, you can navigate to a screen and select the new value in the related drop-down list. For example, you can navigate to the Accounts screen, select a record from the Accounts list, and then select Bronze in the Account Status drop-down list for the record.