Understand SQL Query for Talent profile data model

Apr 25, 2020 9:24AM · Apr 25, 2020 9:24AM

Content

Hi Everyone,

I have created the data model for talent profile print action with the help of delivered data by oracle.

In delivered data model oracle has used a secured list query to get print base on user role.

The same query how can I apply on custom data model just wanted to understand the logic of how it got to build.

Did anyone has done the same anyone of your client?

In a Highlighted red color that query oracle has used.

Select

p.person_id as employee_id,

Ct.Content_Type_Id,

Pi.Item_Text240_1 As employerName,

to_char(Pi.Item_Clob_3) As achievements,