Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
search for phone number in ph_mobile with our without leading 0 — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

search for phone number in ph_mobile with our without leading 0

Received Response
15
Views
2
Comments
edited Jan 18, 2019 10:59AM in Reporting & Analytics for B2C Service 2 comments

Content

Hi,

Currently we have the challenge to find a mobile phone number, that is maintained sometimes with and sometimes without leading 0 (yes I know, that should not be!).

However, I am considering if there could be a kind of logic for a quick search that could bypass the issue of index search without exact search string. Means, if I search with an equal filter, the index is used and I get an immediate response. If I use a like, search is potentially done deferred, which is no solution for an agent.

Is there potentially any complex expression filter possible, that searches exactly, but with both options (so either leading 0 or not) and still meets the index on that field?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!