05-18-2023 08:53 AM
Label:
Copy '|!Prm_SourceScenario_QMC!|' To '|!Prm_TargetScenario_QMC!| ' For A# '|!Prm_SourceAccount_QMC!|' , T#'|!Prm_SourceTime_QMC!|' , V#'|!Prm_SourceView_QMC!|' , F#'|!Prm_SourceFlow_QMC!|'
Button:
{CopyQuorumToForecast_QMC}{Prm_SourceScenario_QMC=[|!Prm_SourceScenario_QMC!|], Prm_TargetScenario_QMC=[|!Prm_TargetScenario_QMC!|], Prm_SourceAccount_QMC=[|!Prm_SourceAccount_QMC!|], Prm_SourceTime_QMC=[|!Prm_SourceTime_QMC!|], Prm_SourceView_QMC=[|!Prm_SourceView_QMC!|], Prm_SourceFlow_QMC=[|!Prm_SourceFlow_QMC!|]}
Solved! Go to Solution.
05-19-2023 09:26 AM
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?
05-19-2023 05:25 AM - edited 05-19-2023 05:28 AM
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).
05-19-2023 09:26 AM
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?
05-19-2023 10:35 AM
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!|}
05-19-2023 10:37 AM
Put square brackets around the parameters in the button Selection Changed server Task Argument.