Question
Cognizant
IN
Last activity: 24 Feb 2025 15:06 EST
How to check whether a property value entered in text control is already exist in a data type record or not ?
Hi Guys,
Could anyone tell me how to check whether a property value entered in text control is already exist in a data type record or not ?
In the attached screenshot, here you can there is one section having a text control "Student ID" . If I enter a value in that data capture control, it should check whether the entered value is already exists in "StudentData" datatype records or not. If it already exists, then it should show error message that it already exists and also it should not allow to go to next step.
How to approach this problem?
***Edited by Moderator Marije to change type from General to Product***
Accepted Solution
Updated: 19 Jan 2023 12:04 EST
NCS Pte. Ltd
SG
Hi @SajjadulI16658324: On change action of the field, you can call a activity / Data transform (you can also use refresh section). In the activity / data transform, use the lookup Data page and pass the parameter accordingly.
See https://docs-previous.pega.com/sites/default/files/help_v72/rule-/rule-html-/rule-html-property/actions.htm to understand how actions can be configured for controls.
Thanks.
NCS Pte. Ltd
SG
You can configure on change refresh section action and run a activity to validate this. If Student ID is the primary key for the data type, you can make use of the lookup data page to check if the Student ID is already available in the system.
Thanks.
Cognizant
IN
Hi @ArulDevan
Can you explain how to make use of lookup datapage using On Change event-action ?
Accepted Solution
Updated: 19 Jan 2023 12:04 EST
NCS Pte. Ltd
SG
Hi @SajjadulI16658324: On change action of the field, you can call a activity / Data transform (you can also use refresh section). In the activity / data transform, use the lookup Data page and pass the parameter accordingly.
See https://docs-previous.pega.com/sites/default/files/help_v72/rule-/rule-html-/rule-html-property/actions.htm to understand how actions can be configured for controls.
Thanks.
Acel Solutions Pvt Ltd
IN
@SajjadulI16658324 have you got the solution for this, if yes can you share the screen shots
Cognizant
IN
@FirdozK02I got the solution and I have already accepted the solution given by @ArulDevan . But I mightn't able to share the screenshot as the solution is implemented in pega personal edition software which I have uninstalled long back.