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  - As of Date is a column in your DB ? then you are trying to pass the param in SQL, if so Did you try calling it Data Adapter first? to see it is working. Then you can hardcode the value in BR.

In my Previous response it is just an example of how you can Call the parameters. 

Tom's avatar
Tom
New Contributor III
8 months 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
    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!

    • 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