Creating an Item

Next, create an item in the Department regions. The item is a select list using the Department list of values.

To create an item:

1. Under Items, click the Create icon.

2. For Item Type:

   1. Select Item Type - Select Select List and click Next.

   2. Select List Control Type - Select Select List with Submit and click Next.

      This option refreshes the page whenever a change is made to the select list.

3. For Display Position and Name:

   1. Item Name - Change to P3_DEPARTMENT_ID.

   2. Sequence - Accept the default, 10.

   3. Region - Select Department (1) 5.

   4. Click Next.

4. For List of Values:

   1. Named LOV - Select DEPARTMENTS.

      Departments appears in the select list because you created it as a shared component, which enables you to use it in other pages.

   2. Display Null Option - Accept the default, Yes.

   3. Null Text - Enter the following:

      - No Department Assigned -
      

   4. Null Value - Enter the following:

      -1
      

      Entering a null value makes it easier for you to write your query and to default your value to that entry. In this case, whenever a user selects - No Department Assigned -, the session state for this item is set to -1, and you can use that value in a query.

   5. Click Next.

5. For Item Attributes, change the Label to Department and click Next.

6. For Source:

   1. Default - Enter -1.

   2. Accept the remaining defaults.

   3. Click Create Item.