08-02-2024 06:20 PM
Hello community,
We have a Custom Calculate DM job that clears data by account and flow via parameter selection that works well.
Our client wants to know if it is possible to select multiple base accounts at once to clear the data. The parameter options such as member filter does not allow selecting more than one account so I'm hoping, if this is possible, that maybe someone has used multiple NameValuePairs to achieve this via two parameters of the same dimension somehow. Throwing ideas that may or may not be good out here. Thanks in advance!
08-04-2024 09:33 AM
Hi there - this is definitely possible and can be setup with one parameter bound to a combo box. In the display format of the combo box, set MultiSelect = True.
Then just make sure to put the parameter in square brackets in the DM Step i.e. AccountList = [|!Select_Accounts!|]. Now the value of the parameter when passed into the business rule through name/value pairs will be a comma separated list.