Subject: RE: try this
@NameLookup function in the Designer help, suggested corrections in red.
In addition to the changes suggested below, I also suspect that the information under “[Exhaustive]” about which directories are searched may actually apply to @NameLookup generally, and the only difference is when the function stops searching for each username.
Also, the advice to use @Text to display the value with @Prompt is just goofy. First, it’s not necessary because the value is already text. Second, it’s not enough because the value is often multivalued – they would need to @Implode it instead. Third, why do we bother to tell them how to display this function’s result when it is not different from how you would display a value generally?
…
[ lookupType ]
Keyword. Specifies the type of lookup to perform. Supply one or more of the following keywords, separated from each other with : (colon):
…
[Exhaustive]
If you specify [Exhaustive], the search for each value in the username argument continues through all directories, even after a matching username has been found. Without this option, the search for each username ends with the first directory that contains a match (however, multiple matches may still be returned from that directory). Searches all Domino Directories listed in the Notes Directory Assistance and returns all information in a text list. This keyword returns values from the local Names.nsf database as well as the mail server’s directory. If the mail server is unavailable, or the Recipient name type ahead setting in the current location document is Disabled or Local Only, it retrieves values from the current name server. If you are using LDAP, it also retrieves values from the LDAP directory. The user’s value is omitted if there is no match found.
Without the [Exhaustive] argument, a value in the user’s local address book may hide values in the server directories. For instance, suppose usernames = “Smith”, and the current user has a “Mary Smith” in their local address book. Unless you specify [Exhaustive], @NameLookup will not notice the entry for “George Smith” in the server address book, and will only return information for Mary.
[TrustedOnly]
Searches only those Domino Directories that contain trust information and returns a list of single text values for each specified user name. An empty string is returned for no match found. Corresponds to NAME_LOOKUP_TRUSTED_NAMESPACES flag for Notes API.
username
Text or text list. Specify primary or alternate Notes/Domino user names to retrieve their information from the Domino Directory.
itemtoreturn
Text. Item or field name from the Domino Directory Contact record that you would like to retrieve information from.
Return value
valuelist
Text list. When other flags besides [Exhaustive] have been specified, @NameLookup returns a list of single values for each matching user. If a given username value matches multiple users, one entry will be returned for each matching user. Unless [Exhaustive] has been specified, an empty string is returned for usernames for which no match was found. When [Exhaustive] has been specified, @NameLookup returns a list of all information matched for the specified user. No value is returned for unmatched users. To display the return values in a dialog box using @Prompt, enclose this function in an @Text function.
In no case will more than one value be returned from each matching contact document. If the requested field is multivalued (e.g. the FullName field), only the first value in the field is returned.