GILOOKUPF function

Created by Damien Zwillinger, Modified on Thu, 5 Oct, 2023 at 5:50 PM by Gabriel Michaud

Applies to:

  • Velixo NX
  • Velixo Classic
  • Acumatica, Cegid, MYOB
  • GI module


The GILOOKUPF function returns the value of a column from a generic inquiry by specifying a Filter to be applied on the server and the Keys of the row to locate.

 

Syntax

This is the syntax for this function:

 

=GILOOKUPF(Connection, Name, Filter, Column, Key1, Key2, ...)

 

Parameters

This function has the following parameters:


Parameters

Required/Optional

Description

Connection

Required

The name of the connection, as specified in the Connection Manager

Name

Required

The name of the generic inquiry.

Filter

Required

The condition that determines which records should be selected from the inquiry.

The recommended way to construct this parameter is by using the GIFILTER helper function. Otherwise, see Advanced Filtering in GI Functions.

Column

Required

The name of the column from which the value will be returned.

Key1

Required

The values for every key column of the generic inquiry. Those will be used to locate the data row in the generic inquiry result set.

Key2

 

 

...

 

 

KeyN

 

 


Example

  =GILOOKUPF("Demo", "VelixoReportsPro-Accounts", C8, "Type", 219)

Description: Suppose the key for the "VelixoReportsPro-Accounts" generic inquiry is configured to be the AccountID field. The above formula will then:

 

  1. Fetch the result set from the generic inquiry, applying the filter specified in the cell C8.

  2. Retrieve a record where the value of the key column (AccountID) is 219.

  3. Return the value of the Type field for this record.


Result: Asset

 

Additional Notes

⚠ For each Generic Inquiry that you use with the GILOOKUPF function, you will need to explicitly specify the inquiry's key columns in the Generic Inquiries Options section of the Velixo options window.

 

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article