Cannot Define Multiple Values for Dashboard Content Process Parameters
Description
Environment
Activity
Peter Takacs March 29, 2023 at 2:13 PMEdited
I see, I thought the ‘s' in your example C_BPartner_IDs=”200000,117” would be part of the syntax So if it is really just ColumnName=”ID1,ID2” than I must remove that part of the code
Carlos Ruiz March 29, 2023 at 2:05 PM
@Peter Takacs - I think the quoting solution is more elegant and clear, just thought you haven’t developed it yet and quoting sounds easier, but if is already done I think quoting is OK.
About the pull request, you’re hardcoding the column ending with “IDs” - but that’s a very difficult assumption, the multi-selection columns can have any name, why do you need to remove the last “s” ?
Peter Takacs March 29, 2023 at 1:49 PMEdited
Hi team, thank you for the suggestions, I’ve already prepared a PR for the quoting solution. But even after reading heng sin’s idea of the escape character, quoting sounds as a better, more sophisticated option to me, and the logic could be improved/reused later nicely. wdyt?
Carlos Ruiz March 29, 2023 at 1:40 PM
I guess another option is to escape it, i.e something like QtyOrdered=10;50,C_BPartner_IDs=200000\,117
That’s right, escape sounds simpler to develop than quoting
Heng Sin Low March 29, 2023 at 1:12 PM
I guess another option is to escape it, i.e something like QtyOrdered=10;50,C_BPartner_IDs=200000\,117
Issue: multi-selection parameters are not supported in Dashboard Content -> Process Parameter field. Defining e.g. C_BPartner_ID=200000,117,50003 (comma separated) throws parsing error, and C_BPartner_ID=200000;117;50003 (semicolon separated) recognises it as a range parameter between 200000 - 50003.
New syntax for defining multi-selection: C_BPartner_ID=”200000,117,50003” as suggested by Carlos