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

Is it possible to pass a presentation variable into SQL code

Received Response
82
Views
2
Comments
edited Sep 19, 2016 2:56PM in Reporting and Analytics 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!