We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
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

contacts.any_phone_raw is not returning data when searching for Contact Phone Alt 3

Received Response
5
Views
2
Comments
edited Sep 10, 2021 2:10PM in Reporting & Analytics for B2C Service 2 comments

Content

We have a search report set up that utilizes contacts.any_phone_raw which based on the Data Dictionary should search within any phone number field on the contact, including all the alts. However, when using this report with a phone number on a contacts Phone Alt 3 field, the contact is not returned. This is not the case when searching for any other Alt Phone Number, the problem only happens when searching specifically for the Phone Alt 3 field. 

 

Example: 

I have a contact setup with the following phone numbers: 

Phone: 123456789

Phone Alt 2: 123456788

Phone Alt 3: 123456777

Phone Alt 4: 123456666

Phone Alt 5: 123455555

When I run the report populating the Phone field with the phone number in Phone, Phone Alt 2, Phone Alt 4, or Phone Alt 5 the contact is returned as expected. When I run the report populating the Phone field with the phone number in Phone Alt 3, there are no records returned. 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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