Monday, June 7, 2010

@DBLookup from a different database present in a different server in XPages

Following is a illustration of how to perform a @DBLookup when the source of data resides in an entirely different database and server.

var dbName=Server-Name+"!!"+Database-Path
 result= @DbLookup(dbName,viewName,lookupKey, {lookupField or column no})
 
This is a small trick which most of us would often forget and wont care about....
It can turn into a real head ache though..... :)
 
Hope this helps.

1 comment:

  1. Thanks IBM for giving us so much adequate documentation.

    ReplyDelete