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
Get Started with Redwood for Oracle Cloud HCM   Begin Now

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!