Notes/Domino XPages Development Forum - ComboBox : Getting values form view in another db

This forum is closed to new posts and responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal

~Bella Bubweakoi

Feb 16, 2012, 4:31 PM

18 Posts

Resolved

ComboBox : Getting values form view in another db

Category: Other
Platform: Windows
Release: 8.5.2
Role: Developer
Tags:
Replies: 2

I have this code to look up values fora combobox

var profDoc:NotesDocument = database.getProfileDocument("DbProfile","");
var db = profDoc.getItemValue("CustomiserRepId");

@DbLookup(db, "Custom", "ActivityStatus", 2);

But I get no values. I have looked around the forums and tested if access was a proble but apparently not.

Any Ideas?

Thanks in advance

~Keiko Minfoosterettu

Feb 16, 2012, 10:33 PM

4 Posts

Re: ComboBox : Getting values form view in another db

What have you defined "database" as?

Try this:

database= new Array(@DbName()[0], @DbName()[1])

var profDoc:NotesDocument = database.getProfileDocument("DbProfile","");

var db = profDoc.getItemValue("CustomiserRepId");

var view = "Custom"

key = "ActivityStatus"

@DbLookup( db, view, key, 2, "[FailSilent]")

I've seen a number of problems with defining "database" and have had problems with it working for local replicas of the database but not for remote replicas. Defining "database" as an array of @DbName with server and database seems to work for anywhere though.

~Bella Bubweakoi

Feb 17, 2012, 11:36 AM

18 Posts

Re: ComboBox : Getting values form view in another db

Thanks that helped loads

Matt