How to Create Search Page using View Criteria in ADF

Search Page is a necessary part of any application / software. You can create search page with create page or also create it separately. In this article I will guide you how to create page using view criteria in Oracle ADF. 

Previously we covered three steps and Now this is forth one.

1)  Create Fusion Web Application.

2) Create Database Connection and Create EO (Entity Object), VO (View Object) and AM (Application Module)

3) Create Task Flow in ADF

4) Create Search Page using View Criteria

4) Create Search Page using View Criteria

•  Double Click on Search View on Task Flow

• When you double click on Search View, you will see popup on your screen, Click Ok

• Search Blank page has been created, now create view criteria

  

•  Go to the Header VO
• Double click on PwcMfgPrintingProductionHVO
• Click on Query 
  
• Click on Bind Variable (+)

• When you click on (+)  sign, Popup window of Bind Variable will be open
1. Name: p_doc_no
2. Remove Required check sign
3. Click on Control Hints

•  When you clickWhen you clickWhen you clickWhen you click
1. Lable Texts: Document No.
2. Display Width: 10
3. Click OK

•  When you click Ok, your Bind Variable has been created.
1. Click View Criteria (+) sign

• Criteria Definition:
1. Click on Add Item
2. Attribute: PpDocNo
3. Operator: Equals
4. Operand: Bind Variable
1. Parameter: p_doc_no 

• Refresh the page. Now you will see under the Name Criteria PwcMfgPrintingProductionVOCrideria  has been created. Now drag and drop into the page.
1. Query + ADF Query Panel with Table

• Edit Table Columns
1. Row Selection: (Single Row, Enable Sorting, Enable Filtering)
2. Columns: Select your columns which you want to display in your search page and change the Display Label
3. Click OK

 

 

• After Click OK, you will ses your Table's Fields + Search Criteria has been created.

Search Page using View Criteria has been created. If you have any query you can ask / comment below.