I am trying to pull a list of values from another DB using DbColumn into a dialog list. When I open the dialog list their are no choices.
The column I am pulling data from has 23,000 records and is sorted Ascending, but when I look at the view directly it says “Not Indexed” in the top right portion of the view to the right of what I think is a standards notes search box. As a sidenote, this view only has one column.
Below is my code in the formula window of the dialog box set to “Use formula for Choices”
@DbColumn(“”;“”:“DBNAME.NSF”;“VIEWNAME”;1)
What am I doing wrong? Have I hit the upper limit on records that can be retrieved using a DBColumn? Can I parse it out to smaller values?
Subject: DBColumn Questions
Make sure the column you’re looking for (1st column) in the view is TEXT. Also if you have db under a directory, you need to specify “ADMIN//DBNAME.NSF” (with 2 slashes) instead of just 1.
Good luck!
hut
Subject: RE: DBColumn Questions
Does it need to be on the same server or directory?? If so, then I guess I need to figure out how to switch it to a DBLookup, because these databases are on completely different servers.
I just assumed notes could find the DB using a GUID querying domino with the DB name.
NM-I just realized the sample I pulled from the help file did not have a server name entry…that was all I needed.
@DbColumn(“”;“SERVERNAME”:“DBNAME.NSF”;“VIEWNAME”;1)
Subject: RE: DBColumn Questions
No, it doesn’t have to be on the same server or directory. just specify the server name and remember to include the folder in front of the database name if it has one (be sure to use double slash), then notes will find it for you.
HTH.