You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Skip to content
  • Register
    • Get Started: AI Resources for Oracle Cloud HCM – Go Here

    Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

    Understand SQL Query for Talent profile data model

    edited Apr 25, 2020 9:24AM in Reporting and Analytics for HCM 3 comments

    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,
    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

    Don't have an account? Click here to get started!