ADF makes it very easy to create a master detail page with one drag and drop operation from the data control palette onto the page.
But what if you want a master with 2 details on one page?
It's actually quite simple to achieve this - but I got asked this a couple of times last week so here goes...
All you need to do is drag the first detail over and drop it as a master->detail.
Then drag the second detail over and drop it as a table or a form - and now you have the three tables on the page and you are almost done.
But if you'll run your page now you'll find that your second detail is not refreshing when you are switching between the master records the way that your first detail does.
ADF did this synchronization part automatically for the first master-detail you dropped. All you are missing is a partial page rendering setting on your second detail.
See the difference between the two detail tables here:
So let's set it up - all you need to do is go to the form or table that contains your second detail and set its partialTrigger property to point to the master component.
(You can look at the setting for your first detail component and copy them).
Comments (4)
Shay, looks like you're using JDev 11g to do this. Does this also work with JDev 10.1.3.1?
Thanks!
Posted by Gerald Winslow | June 4, 2008 5:01 PM
Posted on June 4, 2008 17:01
Yes this work with 10.1.3 also.
Posted by Shay Shmeltzer | June 4, 2008 6:31 PM
Posted on June 4, 2008 18:31
i sucessfully set partial setting as per you. parent form refresing child and when i click child record grandchild table refreshing ok.
when create a record in parent -ok
then i create new record - ok
then i create record in grand child ok
again i click on create record on child table ok.
then i create record in grand child ok.
but when i save i getting forign key error on grandchild table .. mentioning parent key not found.
(in grand child primary key - parentid + childid+ grandchild)
here parentid is missing in grandchild table.
how to solve this problem or is there any sample or link.
parent - adfform
child - adftable
grandchild - adftable
Posted by prafull | January 23, 2009 1:11 AM
Posted on January 23, 2009 01:11
prafull, I think what you are running into is the order of posting entities to the database that is explained in the ADF Developer Guide:
http://download.oracle.com/docs/html/B25947_01/bcadveo007.htm#CEGJAFCF
Posted by shay | January 23, 2009 10:06 AM
Posted on January 23, 2009 10:06