Siebel Tools Reference > Pick Applets and Static Picklists >

Working With Lists of Values

After configuring a new picklist, you may need to add a new list of values to display in the picklist. For example, if you are customizing an applet and want to provide a picklist field that contains a list of values that is not already available in your Siebel application, you can create a new list of values.

Every static picklist includes a type property as part of its definition in Siebel Tools. For example the picklist that allows a user to select the personal title for a contact or an employee has a Type Value property of MR_MS, which in turn is associated with a list of values that includes Miss, Ms, Mrs., Mr., and Dr. To create a new list of values for a custom picklist, you first create a record that defines the new list-of-values type, in which the type corresponds to the type property of a picklist object. You then add records to define each value that will be available for that type.

NOTE:  If you want to see the additions or changes to a list of values in real time, you need to clear the cache.

You can create a new lists of values using Siebel Tools or using the List of Values view in the Siebel Web client. For information about working with existing lists of values, see Applications Administration Guide.

To create a new list of values using Siebel Tools

  1. Choose Screens > System Administration > Lists of Values.

    Lists of values are displayed in the Object List Editor.

  2. Enter new records for the List of Values.

    Some of the fields are described in the table below. For a complete description of LOV fields, see Applications Administration Guide.

    Field
    Description

    Type

    The name of the list of values type, for example REAL_ESTATE_TYPE. This value is used to group all other values for this type. The value defined in this field must match the value defined in the Type Value property of the picklist that is configured to display these values.

    Display Value

    Value displayed in the picklist.

    Language Independent Code

    Typically the same value as the American English version of the display value. See About the Language Independent Code.

    Language Name

    Name of the language for the Display Value.

    For information about fields used for multilingual lists of values, such as Translate, Multilingual, and Language-Independent Code, see Multilingual Lists of Values and Administering the Multilingual List of Values.

To create a new list-of-values type using the List of Values view in the Web client

  1. From the application-level menu, choose View > Site Map > Application Administration > List of Values.
  2. Click New to create a new record, and then enter LOV_TYPE in the Type field.

    This type is used specifically when you want to define a new list of values.

    Enter the text specified as the type property in Siebel Tools. For example, to create a new list of values that will contain real estate types, the type property might be REAL_ESTATE_TYPE. The text you enter here will become the text used for this list-of-values type.

  3. In both the Display Value field and the Language Independent Code field, enter the name of the list-of-values type.

    The Display Value is the value displayed to the user in the picklist.

    The Language-Independent Code is typically the American English version of the display value. For more information about the role of Language Independent Code in a multi-lingual list of values, see Multilingual Lists of Values and Administering the Multilingual List of Values.

  4. Enter a value in the Language Name field.

    After you enter this value, the record has all required information. This list of values has now been created as a new list-of-values type.

    Add the values you want this list to contain by continuing with the next steps.

  5. Click the New button to create another record and enter REAL_ESTATE_TYPE in the Type field.

    This will be the first value for the list-of-values type REAL_ESTATE_TYPE.

  6. In the Display Value field and the Language Independent Code field, enter a value that you want to display in the REAL_ESTATE_TYPE list.

    For example, you might enter Apartment.

  7. Enter a value in the Language Name field.
  8. If applicable, in the Order field, you can enter a number to indicate the numerical order in which the value appears in a drop-down list.

    For example, if you plan to create REAL_ESTATE_TYPE records for Apartment, House, Condo, and Commercial, you might want the order numbers to be 1 for Apartment, 2 for House, 3 for Condo, and 4 for Commercial.

  9. If appropriate, fill in the remaining fields in the record.

    For a complete description of these fields, see Applications Administration Guide.

  10. To add another value to the list, repeat Step 5 through Step 9.

 Siebel Tools Reference
 Published: 20 October 2003