The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

Tom's avatar
Tom
New Contributor III
2 years ago
Solved

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.GetLite...
Connectors
Extenders
  • Krishna's avatar
    Krishna
    2 years ago

    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!

Tom's avatar
Tom
New Contributor III
2 years ago

I currently have the value hardcoded in the SQL, but wanted to create a parameter if possible.  Thanks for your help, I really appreciate it.

Krishna's avatar
Krishna
Valued Contributor
2 years ago

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!

  • Tom's avatar
    Tom
    New Contributor III
    2 years ago

    Krishna,

    it worked, I don't understand the syntax 

    '" & Date & "'

    Thanks so much for your help, I really appreciate it.

    Tom