Friday, April 29, 2022

VBCS - Parent Child Relationship between Business Objects

Use Case:

  • Extend the EmployeeApplication . See my previous blog: https://soalicious.blogspot.com/2022/04/vbcs-sample-web-application-employee.html
  • Create 2nd Business Object "Address"
  • Create a reference between Address and Employee using employeeId
  • Drop a table in the Main page of Employee list and associate the Address BO.
  • Add 1st Filter criteria not to show any default addresses.
  • Add 2nd filter criteria in the employee list event to show only addresses belongs to the selected employee. 

Parent child relationship:


Steps in detail with Screenshots:

Add Business Object - Address.




Default fields:


Add all required fields and a reference Address to Employee BO using Employee id.


All the fields added:


Add one address row.


Go to the employee list main page:


Add a Heading as Address



Add a table >> Quick start >> Add data


Select Address BO.


Add all fields to show


Add field criteria not to show any address rows by default.



employeeId equals to "-1"



Select employee table >> Events


Select event



Add an assign


Click assign


Go to addressListSDP >> filter Critetia >> click to add condition >> employeeId equals to $variables.employeeId






Preview 


Select one employee >> it will show referenced Addresses of that employee.


No comments:

Post a Comment

Featured Post

11g to 12c OSB projects migration points

1. Export 11g OSB code and import in 12c Jdeveloper. Steps to import OSB project in Jdeveloper:   File⇾Import⇾Service Bus Resources⇾ Se...