Posted: 12 Feb 2020 2:10 EST Last activity: 12 Feb 2020 6:30 EST
Fetch Data from External DB Multiple tables using Joins
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');