Question
Staidlogic
IN
Last activity: 16 Jun 2025 6:36 EDT
How to fetch data using phone number with or without country code in Pega?
Hello,
I'm working on a Pega application where I fetch customer details based on the phone number entered in the UI. The data is retrieved using an activity with Obj-Open, matching the phone number stored in the database.
However, users might enter the phone number:
- With country code (e.g., +91XXXXXXXX or 91XXXXXXX )
- Without country code (e.g., 876XXXXXX)
I want the system to retrieve the record regardless of the format entered.
Current Configuration:
- Using Obj-Open in an activity (Get Data) on a data class.
- Matching is done using .PhoneNumber from the Primary page.
- Phone numbers in the database are currently stored with country code.
What I Need:
- A way to normalize the phone number (strip country code or non-numeric characters).
- Possibly store and compare with a consistent what phone number format from call.
- Suggestions on best practices for matching phone numbers reliably (regardless of format).
Has anyone implemented something similar? What's the recommended approach?
Any help or shared pattern would be appreciated.
Thanks!
Capgemini
FR
I think you should identify the possible formats and use if-else conditions to process each format type appropriately.
For example, if phoneNumber starts with +91, do this. I don’t think you would find an out-of-the-box solution that processes Indian phone number formats.
DPIE
AU
@sharadavangimalla use edit input for the phone number property and format it based on the required db format. This way you will keep the format consistent irrespective of how the user enters the number.
Altimetrik
IN
The best way is to first clean the user input using a Data Transform—remove all non-numeric characters using @String.pxReplaceAll() and get the last 10 digits with @String.substring(). Instead of Obj-Open, use Obj-Browse with a filter that matches the last 10 digits of the phone number stored in the DB. This way, whether the input has +91, 91, or nothing, it’ll still match. If possible, store a normalized version of phone numbers in the DB for consistency.
EvonSys
IN
why don't you use obj-browse before Obj-open with filter condition in obj-browser will be Phone Number contains = pass the user entered phone number and pass the fetched phone number from DB to Obj-Open.