[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

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

@DbLookup question

I would like to do a @dblookup on our names and address book (names.nsf) and get a list of names that appear in the first column of the People view.
Help gives the following format but I am having a problem with the key value.  What should I use; it is a standard NAB and it is not indexed.
Thanks
@DbLookup( class : "NoCache" ; server : database ; view ; key ; fieldName ) or
@DbLookup( class : "NoCache" ; server : database ; view ; key ; columnNumber )

0
Chris_m
Asked:
Chris_m
1 Solution
 
CRAKCommented:
If you want the entire column, you need @DbColumn.
Do watch the 64K limit!
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

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