Discussion
Virtusa
IN
Last activity: 21 Jun 2016 18:15 EDT
Data Validation in a pagelist
We had a requirement to ensure that a specific value was not repeated in a Page List.Page list contains list of frameworks.When user tries to select same framework for the second time,error must be thrown .Can any one explain? Thanks in advance.
Pegasystems Inc.
US
You should try to prevent duplicates in the list in the first place.
Use @IndexInPageList().
If a number greater than 0 is returned the value is already there so do not append to the list.
If you are querying try to retrieve distinct rows.
Altimetrik
IN
Their is a page list and i want to find a specific sting(like "am" form "iama") from a list if it is found i required count, Could any one please help me.
Pegasystems Inc.
US
You could try using IndexInPageListWhen(String whenName, ClipboardProperty lookin)
But to do that you would first need to set some Property or Parameter on the Clipboard before calling that Function otherwise the When rule rule would not know what value to compare against a particular Property in each Page of the PageList.
That is, the When rule would encapsulate the "lookAt" Property but is up to you to supply the "lookfor" value through some means.
@String.contains() could be used as the comparison - does not have to be an exact match.
You could perhaps develop your own Function: IndexInPageListWhenLookingFor(String lookfor, String whenName, ClipboardProperty lookin)
That function would set "lookfor" into a parameter then return IndexInPageListWhen().