Tom
8 months agoNew Contributor III
Parameter for SQL
When I have a BR, and need to pull in a parameter, I use the following statement or one similar, I create the parameter in a Dashboard.
'Dim scenario As String = BRApi.Dashboards.Parameters.GetLiteralParameterValue(si, False, "Forecast_Scenario")
How do you bring a parameter into SQL ? I tried the above and it doesn't work. I would like to set a parameter such as date, and then bring the parameter inside SQL, the same way I do as a BR.
Thanks for your help in advance.
Tom
Tom - Assume the below is the parameter in the BR
Dim Date As String = BRApi.Dashboards.Parameters.GetLiteralParameterValue(si, False, ParamName) In the SQL You will be calling the String WHERE SQL COL NAME = '" & Date & "'"
The ParamName is created in the Dashboard Parameter.
Hope this helps!