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

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

    • Krishna's avatar
      Krishna
      Valued Contributor
      2 years ago

      Thanks