Comparing values in one valuelist to another
Hi,
Is there any function in pega that will compare two valuelists' values (order of values do NOT matter) and see if they are a complete match?
ie. list A has: 12,54,65
list B has: 54,65,12 --> This would be true for all values in A are in B
ie. list A has: 12,54
list B has: 54,65,12 --> This would be false because A does not have 65
ie. list A has:
list B has: --> This would be true because A and B are both empty so they match
If there is no function, does anyone have a workaround for this?
Much appreciated,
Thanks!
***Edited by Moderator Marissa to update platform capability tags****
Accepted Solution
Health First
US
You can achieve this by calling this function in a when rule or expression by repeating the following for as many times the size of the ValueList can get:
When @PropertyHasValue(<ValueList Property>(<Index>)) //Check if there's an item at the current index
When @Utilities.IsInPropertyList(<Property in one ValueList to find in other ValueList>,<ValueList name>)
Then do the same vice-versa for the other ValueList
Pegasystems Inc.
US
Hi Sam,
I don't see any OOTB rule to compare 2 page lists together, probably you should try the approach explained below,
https://collaborate.pega.com/question/how-do-i-compare-values-one-pagelist-another
That is the only way you can achieve your requirement as i see.
Regards,
Mahesh M
Pegasystems Inc.
US
Then you should probably go through the below knowledge post and achieve your requirement with the help of the functions specified in the post & in its comments.
https://collaborate.pega.com/discussion/how-check-value-value-list-when-rule
So you should iterate the value list values and compare with the above function specified.
Accepted Solution
Health First
US
You can achieve this by calling this function in a when rule or expression by repeating the following for as many times the size of the ValueList can get:
When @PropertyHasValue(<ValueList Property>(<Index>)) //Check if there's an item at the current index
When @Utilities.IsInPropertyList(<Property in one ValueList to find in other ValueList>,<ValueList name>)
Then do the same vice-versa for the other ValueList