@DbColumn to retrieve from another database

HCL Domino Domino Forum
1

I am trying to retrieve column values from a view located in another database, in the same server.

I’ve tried using:

@DbColumn(“”:“NoCache”;“”:“/foldername/subfoldername/otherdbname.nsf”;“(HiddenViewName)”;3)

But not getting any results. Please help…

2

Subject: @DbColumn to retrieve from another database

A few things you can check:

  • Check that the path to otherdbname is correct

  • Make sure you use double slashes in the path (eg. “foldername\subfoldername\db.nsf”) and ensure the slashes are the right kind (eg. / vs. ) - don’t include any leading slashes in the path either

  • Try unhiding the source view (and change the viewname in the DbColumn statement so that the brackets are removed) to see if that’s the reason the results won’t show

  • Check that the context of the DbColumn statement is correct (DbColumn can’t be used in certain design elements)

Your statement looks alright on the whole - it’s probably a syntax error.

Paul.

3

Subject: Try: @DbColumn(“”; @Subset(@DbName; 1) : “foldername\subfoldername\otherdbname.nsf”; “(HiddenViewName)”; 3)

4

Subject: It works, thanks but…

Your suggestion worked but not i need to figure out a way so that the result generated can be fitted into the combobox. I’m getting the message that it’s over the size limit - I’ve about 2000 entries in the view column…