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



Nov 12, 2013, 10:03 AM
30 Posts

@dblookup with 2 categories

  • Category: Other
  • Platform: Windows
  • Release: 8.5.3
  • Role:
  • Tags:
  • Replies: 2

Hello all,

i have dblookup on a view with 2 categorized columns. Structure looks like this:

http://tinypic.com/r/1z2ktwy/5

As per documentation (http://xpageswiki.com/web/youatnotes/wiki-xpages.nsf/dx/Work_with_DbColumn_and_DbLookup)

I tought this was the answer for getting the dates on picture:

 

@DbLookup( dbname,  "vFreeL2", "Barbariga pri Puli\\št. 098008", 3);

 

But it does not work, return result is empty. Any thoughts??

 

 

Nov 28, 2013, 10:00 AM
93 Posts
Doc Collection

What should column 3 return?

You could try

 

var result  = @DbLookup( dbname,  "vFreeL2", "Barbariga pri Puli\\št. 098008", 3);

Then print or alert result to firstly see what you have and also print or alert typeof result to see what data type is being returned.

 

Also, how are you setting dbname? The problem may lie there. Should be something like:

var dbname= new Array(database.getServer(),database.getFilePath());

 

 

Nov 29, 2013, 2:19 PM
298 Posts
doesn't work that way
If you have a categorized column in the first column and another in the second that syntax won't work, and in fact, nothing will.  You have to use another way to lookup your results like a FTSearch.

The syntax in the help is for when you have a subcategory in the first column.  If you compute your first column to return "Category 1\\subcat1" etc., then that syntax will work.

Howard

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