1 Reply Latest reply: Sep 7, 2013 7:38 AM by oladslw RSS

    If an employee has more than one employment then how to get all the employments?

    Narasimha9082

      Hi,

      there are two tables one is persons and another is employment here is persons_id is the relationship to these tables.

      If an employee has more than one employment then how to get all the employments?

        • 1. Re: If an employee has more than one employment then how to get all the employments?
          oladslw

          Is this an ADF related question? I dont think so.!!!

           

          However you may need to prime your entity relationship skills with database structure.

          if Employee tables has primarykey employee id; if employment table ideally should have a relationship with employees say; employeerefId is a foreign key.

           

          That set, you simply create an association between employeeEO and employmentEO entity objects; and a subsequence viewlink based on the FKAssociation.

          A master detail relationship in your ApplicationModule for both viewobjects; where EmployeeVO is master and EmploymentVO is detail.

           

           

          Ideally you would want to create the employments viewobject as a table on your jsf page or whatever suits your usecase