322 total views, 1 views today

ADF View Criteria

View Object in ADF is representing a table database object supports Select query against the table. View Criteria is adding ‘Where clause’ to the View Objects but Unlike SQL query View Object support multiple View Criteria. The purpose of allowing multiple ADF view criteria is you can choose the ADF View Criteria you want on your pages.

For example, I have an employee table has a column ‘type; with value ‘manager’ and ‘director’. I want to display the list of managers in one page and list of directors on another page. For this, I simply create two View Criteria, One for employee and another for director and use employee VC for employee page and manager VC for manager page.

050816_0135_ViewCriteri1 ADF View Criteria

In this section, we go through about create a two View Criteria for Employee table, one where salary greater than 10000 and other less than 10000 and test it using App Module.

Pre-Requisite

JDeveloper 12.1.3

HR Schema (Comes with Oracle database, the account is locked by default)

View Object from Employee Table (Click here for instruction to create a View Object from a table)

Create a View Criteria

Double Click on the Employee View Object >> Click on the View Criteria >> Click +
icon to add a VC >> Click button Add Criteria >> put rule Salary < 10000 >> Click Ok

050816_0135_ViewCriteri2 ADF View Criteria

 

The VC will get added into your View Object. The same way, create another View Criteria where Salary > 10000.

050816_0135_ViewCriteri3 ADF View Criteria

Test the View Criteria

JDeveloper provides a tool to test the AppModel before you place the object in your UI pages.

Right Click on the AppModule >> Click Run

050816_0135_ViewCriteri4 ADF View Criteria

The AppModule wizard opens on the screen. Double Click on the Employee View Object and click on binocular icon to select the View Criteria

050816_0135_ViewCriteri5 ADF View Criteria

Move the View Criteria you want to test to the Right and click the button Find. (You can choose multiple criteria )

050816_0135_ViewCriteri6 ADF View Criteria

I have selected VC (Salary > 10000) and the data populated with the applied VC. . Move Right and Left and validate the salary value

050816_0135_ViewCriteri7 ADF View Criteria

govindan ADF View Criteria
Connect me

Govind

Thank you for visiting my personal blog. Myself Govindan, Software Developer by profession since 2006 and hence I started this blog early in 2016 and ever since I've been writing about technologies experienced and learnings of everyday life.

The views expressed on this blog are my personal views and do not necessarily reflect the views of my employer.

Please feeling free to reach me on any comments and feedbacks you have. Would be more than glad to listen and reply šŸ™‚
govindan ADF View Criteria
Connect me
By | 2016-12-29T00:19:39+00:00 May 7th, 2016|Categories: ADF|Tags: , , |0 Comments
Like us on Facebook.
Connect!