Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 690
  • Last Modified:

NameLookup does not pull Phone number

I have 2 fields that looks for username, the gets the email address and phone number from user's person document.

Creator_Email: @NameLookup([NoUpdate]; @UserName; "OfficePhoneNumber")
Creator_Ext: @NameLookup([NoUpdate]; @UserName; "OfficePhoneNumber")

The problem is there is one user reported that the extension did not pull out. It came out blank.
1. I have checked on the person document and the phone number is there
2. the email address pull out correctly, but when I tested changing the first letter of first and last name to lower case (ie. Test.User@domain.com to test.user@domain.com), the field that pulls the email address still show up with Upper case.
3. I have tried to take the user.id and test it on a different PC and the problem persists.

Any idea why this happens? I know there are 2 address books set up in the company and that is not ideal but I have checked the 2 address books and make sure all the needed information are there.
0
coronoahcoro
Asked:
coronoahcoro
  • 3
1 Solution
 
IanThCommented:
sounds like there is a problem with the extension number for the affected user like it has a control character or something
0
 
coronoahcoroAuthor Commented:
I have deleted the number and added it back in but still no result.
0
 
umeliCommented:
Did you try to change from [NoUpdate] to [Exhaustive]?
0
 
coronoahcoroAuthor Commented:
Actually I change from [NoUpdate] to [ForceUpdate] and it works ok now
0
 
coronoahcoroAuthor Commented:
Found the solution myself
0

Featured Post

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now