Forum Discussion

brookb's avatar
brookb
New Contributor
2 years ago

Unselect/Uncheck combo box selections

Is there a setting on the component or even a business rule that allows you to uncheck/unselect/reset a combo box to its original state? I would like it to reset and check the top member or a default member. I don't want all parameters on my dashboard reset just a specific combo box with the click of a button.

Dashboards
  • Ashok's avatar
    Ashok
    2 years ago

    yes, you can reset or set to specific value using Dashbaord Extender BR. see "RPTA_SolutionHelper" for examples. something like below:

    '*********************************************************************************************************************************************
    ' PARAMETER COMPONENT SELECTION CHANGED EVENT HANDLERS
    '*********************************************************************************************************************************************
    Case Is = DashboardExtenderFunctionType.ComponentSelectionChanged

     

    If (args.FunctionName.XFEqualsIgnoreCase("ValidateDatesForRefresh")) Then


    Dim taskResult As New XFSelectionChangedTaskResult

    taskResult.ModifiedCustomSubstVars.Add("DashboardToHide_RPTA", "9_NoFilterSelected_RPTAV")

    taskResult.ModifiedCustomSubstVars.Add("ReportLabelHeight_RPTA", "*")
    taskResult.ModifiedCustomSubstVars.Add("FilterLabelHeight_RPTA", "0")

    taskResult.ChangeCustomSubstVarsInDashboard = True
    Return taskResult

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

    yes, you can reset or set to specific value using Dashbaord Extender BR. see "RPTA_SolutionHelper" for examples. something like below:

    '*********************************************************************************************************************************************
    ' PARAMETER COMPONENT SELECTION CHANGED EVENT HANDLERS
    '*********************************************************************************************************************************************
    Case Is = DashboardExtenderFunctionType.ComponentSelectionChanged

     

    If (args.FunctionName.XFEqualsIgnoreCase("ValidateDatesForRefresh")) Then


    Dim taskResult As New XFSelectionChangedTaskResult

    taskResult.ModifiedCustomSubstVars.Add("DashboardToHide_RPTA", "9_NoFilterSelected_RPTAV")

    taskResult.ModifiedCustomSubstVars.Add("ReportLabelHeight_RPTA", "*")
    taskResult.ModifiedCustomSubstVars.Add("FilterLabelHeight_RPTA", "0")

    taskResult.ChangeCustomSubstVarsInDashboard = True
    Return taskResult

    • Krishna's avatar
      Krishna
      Valued Contributor
      2 years ago

      Are you sure this is working ? I am not able to get it working. Can you share more details. I followed the same but it is not working.

    • Krishna's avatar
      Krishna
      Valued Contributor
      2 years ago

      I answered my own question. I was passing the incorrect parameters. Param Name Vs ComboBox Name. Thanks.

  • Gidon_Albert's avatar
    Gidon_Albert
    Contributor II
    2 years ago

    So if I understnad this right, in :

     

     

    taskResult.ModifiedCustomSubstVars.Add("DashboardToHide_RPTA", "9_NoFilterSelected_RPTAV")

     

     

    => DashboardToHide_RPTA is the paramter

    => "9_NoFilterSelected_RPTAV" is the value we assign to this parameter

    And by using setting :

     

     

    taskResult.ChangeCustomSubstVarsInDashboard = True

     

     

    OneStream will use "9_NoFilterSelected_RPTAV" when |!DashboardToHide_RPTA!| is referenced. Is this correct?

    Is there a way to get the value assigned to |!DashboardToHide_RPTA !| in the previous run of the current dashboard to avoid another value from another user from being used by the current user?