Forum Discussion

Tom's avatar
Tom
New Contributor III
8 months ago

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
    8 months 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!

Krishna's avatar
Krishna
Valued Contributor

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
8 months ago

Krishna,

it worked, I don't understand the syntax 

'" & Date & "'

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

Tom