Question
AAA
US
Last activity: 12 Jun 2019 2:33 EDT
Passing multiple values to one Parameter
Can someone please advise what is the syntax for passing multiple values for a parameter?Please see attached document. I am looking to pass multiple values for the Product ID in order to only get those rows back from datapage sourced by report definition.
***Edited by Moderator: Pallavi to update platform capability tags***
AAA
US
Hi, I have tried this before and it works to send on value for multiple parameters but what I want to know is how do I pass more than one value for ProductID? I tried ProductID: Your value, ProductID: your value but that did not work.
Thanks
Pegasystems Inc.
IN
Hi ,
Use property set method..
Source side : param.your_property/.your_property
Target Side:D_ProductList[ClubCode: Your value, ProductID: your value, RoleCode: your value].your_property
Regards,
Vinay Reddy
Accenture
SG
Hi Christina,
Pass the parameter values by putting them in quotes and comma separated.
For Ex: you need to get details for Address with HOME and OFFICE as values then pass "HOME","OFFICE" as values to parameter Address.
Pegasystems Inc.
PL
In such scenarios I would suggest more object oriented solution - some kind of DTO. In Pega (depending which rule) you are able to pass page name as parameter. You can create some class or use existing one which could represent key-value list and then you can pass its name via parameter and use it as simple clipboard page. Usually if I need to pass more structured or complex data via param I choose this solution.
Accenture
AU
Hi,
In RD, when multiple values are selected it would be presented in this format {"ABCD","DEF"}, and the SQL that is generated uses 'IN' clause rather than 'EQUAL TO'.
So, the parameter should have values in the above format, which can be achieved using StringBuffer-Append method.
Regards,
Vipul