phone number search

[samadam]

I am trying to search phone number field from user record from incident but only exact search is giving the right results if my phone is stored with "-" and I use / it does return right results. Does the user have to search with exactly as it appears on the user form?

[arthikamugundan]

Hi Sam,

I assume you are searching within the list of records then the search must match the exact values.

To read further on how search works in Servicenow

Introduction to Searching - ServiceNow Wiki

Thanks,

Arthika N

[samadam]

Thank you, I am trying to look up a user based on phone number and exact match is bring up the user but if it just type in with spaces or just numbers (any other format other than what is stored) it gives totally different set. Is there a way to wild card it?

[David OBrien]

I don't know that you could wild card it, but you could create a secondary phone number field that you search instead and have it be a calculated field that takes the phone number field and strips out any special characters so it's just a numeric field.

[bernyalvarado]

Hi Sam, you can give it a try to search using star (*). For instance, if the user's number is (111) 222-1133, you could then try searching for *222 and it should return as part of its results the user record with the phone (111) 222-113 and any other user which phone number contains 222.

I hope this is helpful!

Thanks,

Berny