How to setup validation to check if the input value duplicate in a data page record?
I have a Data Page called CarList. And in the case creation form there is a "carID" input field. I would like to add a validation so that the form can return warning and not to proceed if the user entered a duplicated carID. But I cannot find a suitable function in validation to do the checking with the data page. Anyone has faced this issue before or has any suggestion on that? Thanks.
Accepted Solution
Updated: 28 Oct 2022 19:53 EDT
Eclatprime Digital Private Limited
IN
@Valor Hi
Try this Approach
In that select function, Select the expression evaluates true.
In that you have to use the expression is: D_CarList[carID:.carID].pxResultsCount>0
It will check the any duplicate value present in that D_Page. If it is present the result count is 1 and it will throw the error. If it is not present, then it will continue case.
Thanks
NCS Pte. Ltd
SG
Hi @Valor: Can you confirm if the below understanding is correct
- CarID is a single value property
- CarList Data page is the source for dropdown
In this case, what you are you trying to validate? Can help to understand this.
If you are looking for duplicate validation, you can select expression evaluates to true and can use functions like countinpagelist, removeduplicates to validate your scenario.
If this not the scenario, can you share some additional details on your configuration masking confidential details?
Thanks.
Pegasystems Inc.
IN
@Valor Hi,
Can you please check using the below functions?
If that doesn't help you can use expression evaluates to true and use your logic using is in pagelist and is in pagelist when and then set the error message
Accepted Solution
Updated: 28 Oct 2022 19:53 EDT
Eclatprime Digital Private Limited
IN
@Valor Hi
Try this Approach
In that select function, Select the expression evaluates true.
In that you have to use the expression is: D_CarList[carID:.carID].pxResultsCount>0
It will check the any duplicate value present in that D_Page. If it is present the result count is 1 and it will throw the error. If it is not present, then it will continue case.
Thanks