Question

1
Replies
683
Views
Paris Qian Sen (ParisQ07)
NCS Group

NCS Group
SG
ParisQ07 Member since 2017 20 posts
NCS Group
Posted: March 14, 2018
Last activity: March 20, 2018
Posted: 14 Mar 2018 3:29 EDT
Last activity: 20 Mar 2018 4:31 EDT
Closed

Multiple Database Tables mapped to a Single Concrete Classes?

Greeting, Pega experts,

We have a typical Teacher-Students-Person scenario.

Let's say we have one Class called Teacher, containing Columns like TeacherID, IC No, Name, DOB, Salery, YearsOfTeaching etc.

There is another Class called Student, containing following Columns: StudentID, IC No, Name, DOB, LastScore, DateOfEnrolment, etc.

Can we store common columns,"IC No", "Name" & "DOB", into a Database table called "Person"?

Here is my thought:

Could we create a Person Class in PEGA, containing those properties incl. "IC No, Name & DOB".

Then let both Student & Teacher class inherit from it.

Then specify "External Mapping" for Student and Teacher classes.

Is it doable? How to configure the table joining?

I know that report definition can be used to form Data Pages, but when we set it as "Editable", will Pega know which table to update, and how to update?

Data Integration
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.