Table Of Content
Creating a Search Page in ADF BC using Parameter Form and display on ADF Table
View more Tutorials:
-
1- The objective of this example
-
In this post, I will show you how to create an ADF Fusion Web Application. Displaying data in webpage under Table Form and has Parameter Form to filter data.
-
Below is the image of the application
-
-
2- Create Application
-
The steps for creating an "ADF Fusion Web Application" and connecting to a database, which can be seen by you at:
-
This is the application image with basic setups:
-
-
3- Create View Object with parameters.
-
On the JDeveloper, select:
-
- File/New/From Gallery...
- >> Business Tier/ADF Business Components/View Object
- File/New/From Gallery...
-
-
-
Enter a query sentence:
-
Select e.Employee_Id ,e.First_Name ,e.Last_Name ,e.Email ,e.Phone_Number ,e.Hire_Date ,e.Job_Id ,j.Job_Title ,e.Salary ,e.Commission_Pct ,e.Manager_Id ,e.Department_Id ,d.Department_Name From Employees e ,Departments d ,Jobs j Where e.Department_Id = d.Department_Id And e.Job_Id = j.Job_Id And (e.Salary >= :Sal_Min Or :Sal_Min Is Null) And (e.Salary <= :Sal_Max Or :Sal_Max Is Null)
-
-
Create the two parameters of Sal_Min and Sal_Max with Number type.
-
-
-
-
With a customized "View Object", you only need to clearly define "Key Attribute" (Primary key attribute). In this example, it is EmployeeId column.
-
-
-
-
-
View Object: V02Employees has been created:
-
-
You need to register V02Employees with Application Module. After being registered, it can be used by other Project of the application.
-
Open AppModule:
-
-
-
V02Employees have been seen on "Data Controls":
-
-
4- Create View
-
On ViewController open adfc-config.xml:
-
-
Search for "view" keyword and drag and drop "View (ADF Task Flow.Components)" into "Diagram" window of adfc-config.xml.
-
-
An object has just been created. Change its name as empList2.
-
-
Double click on the "empList2" to create a source file.
-
Note: You should place the source file (jsp, jsf,..) in the WEB-INF folder or the subfolder of the WEB-INF. It helps to hide these files with users.
-
-
-
5- Design interface for View
-
Search with keyword "Stretch",drag and drop "Panel Stretch Layou (ADF Faces.Layout)" into "empList2.jsf".
-
-
PanelStretchLayout has 5 Facets (also 5 regions). Delete 3 regions "start", "end", "bottom":
-
-
Search with keyword "panelbox", and drag and drop "Panel Box (ADF Faces.Layout)" into "Top" and "Center" region of empList2.jsf:
-
-
-
Drag and drop V02Emp1 from "Data Controls" into the "Employees" region of empList2.jsp to create an ADF Table:
-
-
Delete some columns that you don't want to display on the ADF Table.
-
-
-
-
In the next step, drag and drop "ExecuteWithParams" of V02Emp1 into "Search" region of empList2.jsf to create "ADF Parameter Form...":
-
-
-
"ADF Parameter Form" has been created, you can drag to increase the height of "Search" region.
-
-
6- Run the application
-
Select "empList2" on the adfc-config.xml and click the Run icon (Or F11).
-
-
-