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
    • Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now

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

    Is it possible to pass a presentation variable into SQL code

    edited Dec 13, 2022 7:02AM in Taleo Enterprise 2 comments

    Summary

    Is it possible to pass a presentation variable into SQL code

    Content

    Is it possible to pass a presentation variable from a prompt into the SQL Code?  I am looking to insert the prompt variable into the sql on the advanced tab in the analysis.  Below is basically what I am trying to do. 

    For Instance: 

    Prompt_Date: 9/6/2016 

    Select field 
    From Table 
    Where Date = Prompt_Date 
    Union All 
    Select Field 
    From Table 
    Where Date = Prompt_Date  

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

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