Have a DBLookup I am working on whick references an Agent ID "dai" and then pulls in the username for that agent. The list of agents is in the 2700 range, when I refresh the doc, I only get a name in 70 cases, where there should be well over 2000 that will match. Is there an issue with the number of agent records? What would be a fix for this issue?
@IfError(@DbLookup( "" : "NoCache" ; "" ; "usernames" ; dai ; 2); "Name Not Available")