Saturday, 11 June 2016

How to Create View Link in ADF

Hi Everyone in this post i simply show you how to create ViewLink between two View Objects in ADF
For this post i have created two SQL Query base view objects  , name as
EmpQB and
DeptQB
if you don't know how to create Query base view object please visit the following Link

http://adfindepth.blogspot.com/2016/06/sql-query-base-view-object-manually.html 

To create View Link
Just Right Click on Model and select New


Then from the "New Gallery" select ADF Business Components form categories and View Link from Items and then click OK


In next window select View Link Name and Display Name and click on Ok


In next window select DepartmentId from DeptQB in "Select Source Attribute" side (Master table)
Then from EmpQB also select DepartmentId in " Select Destination Attribute" side   (Detail table)
click on "Add"
and Then click on Next



Next window show the properties of View Link    , for now we go with the default properties , Just click on Next


Again Just click on Next


Again Next




In next window you can add an instance of this view link to an AppModule
For this checked the "Add to Application Module " check box
Then click on Browse and select AppModule and click on OK
Now Click on Next


The next window just show the summary about this View Link
click on Finish


Now to check view Link properly created or not
Right Click on AppModule and select Run


From the New Window double click on DeptNdEmpVL and check data , it will be look like the following pic





Now move to next Department by click on arrow sign and you will see the employees data will also change
according to Department





Please Feel Free To Ask if you Face any Difficulty 
Like and share to help others
Thanks
Date 10-06-2016

No comments:

Post a Comment

Query to get Business unit (ORGANIZATION_ID) Detail in oracle Fusion

  SELECT HAO.ORGANIZATION_ID AS BUSINESS_UNIT_ID,         HAOT.NAME,         HAO.BUSINESS_GROUP_ID,         HAO.EFFECTIVE_START_DATE,       ...