o7planning

Creating LOV (List Of Values) in Oracle ADF BC

View more Tutorials:

1- The Objective of the Lesson

In this lesson, I will show you how to create and use the LOV (List Of Values) in the Oracle ADF application.
For example, you create an ADF Form to enter staff information. The staff information includes: Full name, Salary, Department,.. The information on departments will be selected through a LOV (List Of Values), which is like the following illustration:

2- Create an application

First of all, you need to create an ADF Fusion application with basic settings.
  1. Create "ADF Fusion Web Application".
  2. Connect to a database.
  3. Create Application Module.
  4. Create Entity Objects.
  5. Create default View Objects.
You can see the following instructions:
After the above steps, you obtain an application like the illustration below:

3- Use ADF Model Tester

The ADF Model Tester is a tool available on the ADF helping you test  View Objects. In this lesson, I will use it to test the View Objects after each configuration of the View Object.
For example, you want to test V00Employees (View Object).
Note: To be able to test, the V00Employees (View Object) have to be registered with the Application Module.

4- Create the View Object based on two Entity Objects

Create a View Object named V03Employees based on 2 Entity Objects such as Employees and Departments.
Note: The two Entity Objects: Employees and Departments  have constraints with each other by an association. It is a a concept corresponding to the concept of Foreign Key in the Database.
On the JDeveloper, select:
  • File/New/From Gallery
    • >> Bussiness Tier/ADF Bussiness Components/View Object
Select Employees (Entity Object):
Next, select Departments (Entity Object):
Select columns for the View Object which is being created by you. They are columns from the two Entity Objects (Empoyees & Departments).
The V03Employees (View Object) has been created:
Then, you need to register the View Object which you have just created with the Application Module:
And you can see this View Object on the Data Controls.

5- Create LOV View Object

On the JDeveloper, select:
  • File/New/From Gallery
    • >> Bussiness Tier/ADF Bussiness Components/View Object
Enter:
  • Package: org.o7planning.adf.model.lovviews
  • Name: LOVDepartments
Select d.Department_Id
      ,d.Department_Name
      ,Loc.City
From   Departments d
      ,Locations   Loc
Where  d.Location_Id = Loc.Location_Id(+)
Order  By d.Department_Name
 

6- Create UI Hints for the View Object

ADF Tool helps you create the parts of the (ADF Form, ADF Table, ...) websites easily by  dragging and dropping the View Object into the design screen. However, you need to set up hints for the ADF Tool.
The Department_Id is the Primary Key Column of the table of DEPARTMENTS. When creating a new employee (Table of EMPLOYEES), the user have to select a department for this employee from a LOV (List Of Values).
Open the V03Employees (View Object):
Select the DepartmentName  Attribute and create a  "List Of Values" for it.
Transfer to the TAB - UI Hints:
After setting up the UI Hints for the V03Employees (View Object), you can test it on the ADF Model Tester:

7- Create ADF Form and LOV

Open adf-config.xml:
Drag and drop a View object into the adf-config.xml window:
Double click on the emp3 icon (as the illustration) to create a corresponding source file for it .
Search "Decorative Box (ADF Faces.Layout)" and drag and drop it into the emp3.jsf window:
Drag and drop the V03Employees1 from the Data Controls into "Center" region of the emp3.jsf window and create an ADF Form.
Delete the two columns of DepartmentId and DepartmentId1 :

8- Run the application

Select the emp3 icon on the adf-config.xml window and press RUN to run the website:

View more Tutorials: