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



~Isaac Brefoovitchoni
Jan 31, 2012, 2:18 PM
46 Posts
topic has been resolvedResolved

Value of the second field

  • Category: Other
  • Platform: Windows
  • Release: 8.5.2
  • Role:
  • Tags:
  • Replies: 4
How to get value from the second field in situations when looking through @DbLookup:
 

In DbLookun my key is "e" - how to display the value  "75" located in the second column?
 

~Rex Umreman
Jan 31, 2012, 2:35 PM
272 Posts
Re: Value of the second field
Hi,
 
just use the column number in the @DbLookup
 
@DbLookup(dbName:string, viewName:string, key:string, colNumber:int, keywords:string) 
 
Hope this helps
Sven
 
~Isaac Brefoovitchoni
Feb 1, 2012, 11:07 AM
46 Posts
Re: Value of the second field
Hi Sven, i create Computed Field with:
 
@DbLookup("", "ViewName", aaa, 2);
 
But no results and no error
~Isaac Brefoovitchoni
Feb 1, 2012, 12:05 PM
46 Posts
Re: Value of the second field
My mistake - column should be sortable.
 
Thanks for your help Sven
~Rex Umreman
Feb 1, 2012, 12:11 PM
272 Posts
Re: Value of the second field
Which value does aaa contain ?

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