Question

1
Replies
233
Views
Close popover
Venkata Gowtham Maharoju (Venkata Gowtham M)
Process 360
Consultant
Process 360
SA
Venkata Gowtham M Member since 2017 6 posts
Process 360
Posted: February 12, 2020
Last activity: February 12, 2020
Closed

Fetch Data from External DB Multiple tables using Joins

Hi Team,

 

I have an requirement to connect to Oracle DB and fetch data from multiple tables using Join Query. I have created an Data base and database table as well.But my query is " How to map single pega class to mutiple tables of external DB?

 

Below is Query to be used:

 

select be.design_id,us.full_name, be.status,dname.attribute_value as DESIGN_NAME from bam_dba.O2B_Business_Entity be     left join bam_dba.O2B_Business_Entity_Details bed on bed.entity_id = be.entity_id and bed.attribute_key ='CREATED_BY_EID'     left join bam_dba.O2B_Business_Entity_Details dname on dname.entity_id = be.entity_id and dname.attribute_key ='DESIGN_NAME'     left join BAM_DBA.O2B_REF_USER us on bed.attribute_value = us.EID     where be.source_system = 'VISE' and be.design_id in ('543997');

 

 

 

Regards

Gowtham.  

Pega Knowledge 8.3 Low-Code App Development App Studio
Moderation Team has archived post,
Close popover 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.