Forum Discussion

RC's avatar
RC
New Contributor
2 years ago

When selecting multiple items in the list box only the first one is being passed to the Finance Rule

The display of the parameter shows 2 Accounts selected but when retrieving the parameter in the business rule only the first one is passed. If I display the list box selections on the dashboard it ...
  • EricOsmanski's avatar
    EricOsmanski
    2 years ago

    As long as you have [] around the parameter it should pass the entire comma separated string to the rule. I have never had an issue. Only when you don't have [] around the parameter does it pass only the first value. Looks like you do have the brackets appropriately in the button, though.

    Can you screenshot the button?

JackLacava's avatar
JackLacava
Honored Contributor

Works fine here (7.4).

 

If args.CustomCalculateArgs.FunctionName.XFEqualsIgnoreCase("rounder") Then
	api.LogMessage("fired")
	Dim sb As New StringBuilder()
	For Each kp As KeyValuePair(Of String, String) In args.CustomCalculateArgs.NameValuePairs
		
		sb.Append($"{kp.Key} {kp.Value}")
	Next
	api.LogMessage(sb.ToString)

 

The value contains all items, separated by comma and space.

For extra-safety with commas, you can try surrounding the parameter with double-quotes (which you'll then have to strip).

EricOsmanski's avatar
EricOsmanski
Valued Contributor
2 years ago

As long as you have [] around the parameter it should pass the entire comma separated string to the rule. I have never had an issue. Only when you don't have [] around the parameter does it pass only the first value. Looks like you do have the brackets appropriately in the button, though.

Can you screenshot the button?

  • RC's avatar
    RC
    New Contributor
    2 years ago

    button:btn_ExecuteActualsCopy_QMC

    Changes to Defaults:

    Description: Execute Copy of Actuals

    Text: Execute Copy

    Display Format: BackgroundColor = XFDarkBlueBackground, Bold = True, BorderThickness = 1, FontSize = 14, Height = 30, HorizontalAlignment = Center, TextColor = White, VerticalAlignment = Center, Width = 200

    Button Type: Standard

    Selection Changed Server Task: Execute Data Management Sequence

    Selection Changed server Task Arguments: {Corp_Model_Utility_Copy_Actual}{CurCube=Planning,CurEntity=EQT_Import,CurParent=,CurConsol=USD,Prm_TargetScenario_QMC=[|!Prm_TargetScenario_QMC!|],Prm_SourceTime_QMC=[|!Prm_SourceTime_QMC!|],CurClear=False,Prm_SourceScenario_QMC=[|!Prm_SourceScenario_QMC!|],Prm_SourceAccount_QMC=|!Prm_SourceAccount_QMC!|,Prm_SourceView_QMC=|!Prm_SourceView_QMC!|,Prm_SourceFlow_QMC=|!Prm_SourceFlow_QMC!|}

     

    • EricOsmanski's avatar
      EricOsmanski
      Valued Contributor
      2 years ago

      Put square brackets around the parameters in the button Selection Changed server Task Argument.