Shay Shmeltzer's Oracle Development Tools Tips

Implementing Master/Detail in Oracle Visual Builder Cloud Service

Shay Shmeltzer
Director of Product Management - Oracle

This is a quick demo that combines two techniques I showed in previous blogs - filtering lists, and accessing the value of a  selected row in a table. Leveraging these two together it's quite easy to crate a page that has two tables on it - one is the parent and the other is the child, once you select a record in the parent the child table will update to see only the related child records.

Here is a quick demo:

The two steps we are doing are:

  • Create an action flow on the change of first-selected-row attribute of the table
  • In the flow use the assign variable function to set the filterCriterion of the child table to check for the value selected in the master

As you can see - quite simple.


Join the discussion

Comments ( 2 )
  • Khalid Wednesday, November 25, 2020
    How to build a master detail using service connection instead of business objects. Like in Customer and Customer transactions. Can you plz post a sample vdo
  • Shay Shmeltzer Wednesday, November 25, 2020
    Khalid, The same concept would work with other REST services - after all, the communication to BOs is done with REST calls also.
    Basically you'll need a REST service that returns the details for a specific master id, then call this service when you click on a specific master passing the master id.
    This video shows an example of working with REST service to fetch specific records - https://www.youtube.com/watch?v=Rm1g6Ipf23U&list=PLSKf-atSzZegXDK01C6l3jR8XCBxr7Iah&index=6
    If you have additional questions try our forum:
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.