how to check given phone number exists or not in database
Hi Shanmuga,
I have created phone number validation on button click as well as onchange. Please check the attached OML file
I hope this OML helps you.
Thanks,
Purva
For checking records exists or not in database you can use aggregate to query with filter phone number attribute = the given one. Then if aggregate return empty list => the given one is not existed.
You can write above code into a server action and call it to check. OR you can query all phone number at one (using aggregate) then checking in client action by using ListAny from System reference.
Regards,
Khuong
Hello SHANMUGA PRIYA ,
I have create sample demo screenname(numbers,numbersdetails) and attached working URL as well.note(only validation for checking number present or not rest things not implemented)
https://akshayproject.outsystemscloud.com/Rolecheck/Numbers
Thanks and Regards,
Akshay Deshpande
Two scenarios you can consider:
Hope this helps.
Best regards,
Paulo Moreira