Question
Capgemini
MX
Last activity: 20 Oct 2022 23:34 EDT
Join two page lists into one
I need the selected data from two exactly the same multiselect to be joined in a third, without the selected data in the first being repeated in the second. How could I do that? i am newbie in PEGA
TSPi
US
@EdgarIvanV use data transform Append to in actions in the first step with first page list property int he relation use for each page in . Target should be third pagelist property . When you use you see a key symbol in that write condition as selectors property = true
then repeat the same for second page list property
Capgemini
MX
@Satish Sudagoni Hello, Could you explain to me what you mean by "write condition as selectors property = true"?
NCS Pte. Ltd
SG
Hi @EdgarIvanV: If i understand this correctly, there are 3 multiselect in UI. when user selects any data in the first or second multi select, the third multi select should be be populated with unique records of 1 and 2.
If this is the case, you can have a on change in the 1 and 1 multi select to run a data transform to copy the page list to the 3rd page list. Regarding unique items, you can use remove duplicate function / can use conditional append using isinpagelist function.
If this is not the scenario, can help to share a screenshot masking confidential data?
Let us know if this helps.
Thanks
Capgemini
MX
@ArulDevan Hello, Could you provide an example of your suggestion and how I can use the deduplicate function you mention?
NCS Pte. Ltd
SG
Hi @EdgarIvanV: Add a data transform on change of 1, 2 multi select. In the data transform, perform below steps
- Remove target property so it will get recreated again
- Loop page list 1, append to target
- Loop page list 2, append to target
- Use the function @pyRemoveDuplicatesFromPagelist(Primary,"Test1","ID") to remove duplicates. In this example duplicates will be removed from Primary.Test1 page list based on property ID.
Please let us know if you need further assistance.
Note: If your multi select will hold huge number of values, it is better to perform this on a button click instead of refresh to reduce application impact.
Thanks.