Question

1
Replies
106
Views
Venkata Gowtham M Member since 2017 6 posts
Process 360
Posted: February 12, 2020
Last activity: February 12, 2020

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
Share this page LinkedIn