Forum Discussion

SeanV's avatar
SeanV
New Contributor III
2 years ago

Get selected value from Combo Box and use it in a Table View

I have a dashboard that has 2 components,. 1. A Combo Box that is populated with a sql query in a Bound List Parameter. 2. A Spreadsheet that is populated with a Table View.   The table view is g...
Dashboards
Spreadsheet
  • SeanV's avatar
    SeanV
    2 years ago

    Thank you for the response.   

    I wasn't ablet to get BRApi.Dashboards.Parameters.GetLiteralParameterValue to pickup the parameter from the Combo Box.

     

    However I used  args.CustSubstVarsAlreadyResolved("parameterNameHere") and assigned that to a string variable.  That did work.  It got the parameter value from the combo box.

SeanV's avatar
SeanV
New Contributor III

Thank you for the response.   

I wasn't ablet to get BRApi.Dashboards.Parameters.GetLiteralParameterValue to pickup the parameter from the Combo Box.

 

However I used  args.CustSubstVarsAlreadyResolved("parameterNameHere") and assigned that to a string variable.  That did work.  It got the parameter value from the combo box.

Krishna's avatar
Krishna
Valued Contributor
2 years ago

Could you please provide the sample BR ? for the parameter from ComboBox ?

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

    p_Select_Year is the Parameter.

    There was a larger issue at play here, I first set this up on a 6.8x version and it wasn't working (The table view in a dashboard wasn't picking up the selection from the combo box) then I tried it on a 7x version and it worked.

     

    Public Function Main(ByVal si As SessionInfo, ByVal globals As BRGlobals, ByVal api As Object, ByVal args As SpreadsheetArgs) As Object
    Try
    Select Case args.FunctionType

    ' Case Is = SpreadsheetFunctionType.Unknown

    Case Is = SpreadsheetFunctionType.GetCustomSubstVarsInUse
    If args.TableViewName.XFEqualsIgnoreCase("UserLogonActivity")
    Dim paramList As New List(Of String)
    paramList.Add("p_Select_Year")
    Return paramList
    End If

    Case Is = SpreadsheetFunctionType.GetTableView
    If args.TableViewName.XFEqualsIgnoreCase("UserLogonActivity")
    Dim currentYear As String = args.CustSubstVarsAlreadyResolved("p_Select_Year")
    Return GetUserLogonActivity(Si,currentYear)
    End If

    ' Case Is = SpreadsheetFunctionType.SaveTableView

    End Select

    Return Nothing
    Catch ex As Exception
    Throw ErrorHandler.LogWrite(si, New XFException(si, ex))
    End Try
    End Function

    • Krishna's avatar
      Krishna
      Valued Contributor
      2 years ago

      Thanks for the Quick response. Appreciated. p_Select_Year is a parameter correct ?

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

        Yes