Notes/Domino XPages Development Forum - Getting "Infinity" as the result of a @DbColumn in a combobox

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

~Denise Elhipilyoopsi

Feb 15, 2012, 3:34 PM

68 Posts

Getting "Infinity" as the result of a @DbColumn in a combobox - figured it out

Category: Debugging
Platform: Windows
Release: 8.5.2
Role: Developer
Tags:
Replies: 3

Update: I used type ahead in an edit box to get around this.

=========================================================================================================================================

I have a combobox that is doing a simple @DbColumn lookup to a view. I am using similar code in other comboboxes, and it works fine. On the xPage, I'm getting "Infinity" as the result. I'm guessing that the view column has too much data (a list of over 5,000 company names).

In the Notes client, I'm using @Picklist for this. What is the equivalent in xPages?

~Umberto Xanweter

Feb 15, 2012, 10:55 PM

18 Posts

Re: Getting "Infinity" as the result of a @DbColumn in a combobox - figured it out

XPages has a 32 or 64 ( can't remember which ) limit for the lookup formula whereas in Notes the limit is only for the whole of the formula e.g. after @unique is applied.

It makes it very hard to have meaningful drop downs for filtering data.

~Rex Umreman

Feb 16, 2012, 10:52 AM

272 Posts

Re: Getting "Infinity" as the result of a @DbColumn in a combobox - figured it out

Hi,

you can use SSJS instead:

var lookupView:NotesView = database.getView("<LOOKUPVIEW>");
lookupView.getColumnValues(0)

is equivalent to

@DbColumn( "","<LOOKUPVIEW>", 1 );

but brings you the full result w/o the limit.

Hope this helps

Sven

http://blog.hasselba.ch

~Denise Elhipilyoopsi

Feb 16, 2012, 3:40 PM

68 Posts

thanks!

I was able to get it working with Type Ahead (a very cool feature). But I appreciate the lookupView tip, that's very useful, thanks!