X

Shay Shmeltzer's Oracle Development Tools Tips

Master with Two Details on the Same Page

Shay Shmeltzer
Director of Product Management - Oracle

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.


md1:


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:


md4:


md5:


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).

Join the discussion

Comments ( 5 )
  • Gerald Winslow Wednesday, June 4, 2008
    Shay, looks like you're using JDev 11g to do this. Does this also work with JDev 10.1.3.1?
    Thanks!
  • Shay Shmeltzer Wednesday, June 4, 2008
    Yes this work with 10.1.3 also.
  • prafull Friday, January 23, 2009
    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
  • shay Friday, January 23, 2009
    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
  • guest Saturday, September 6, 2014

    Hi,

    I am creating three ViewObjects, all the three based on Queries(involving GROUP BY and JOIN). All the three view got common key attribute. One among them got the the key value Unique which i am keeping as Master and the remaining two got multiple values for each key in the master. so One Master and two detail VOs.

    But When I create the ViewLink, i am not able to put the two details under the Master ? any Idea

    Thanks in advance,

    Binu


Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.