Velixo recommends the use of Microsoft 365 for this feature. Experimentally, Excel 2010 or higher can be used. For prerequisites and an overview of Generic Inquiries, see Introduction to Generic Inquiries. |
Description
The GILOOKUP function returns the value of a specific column from a Generic Inquiry by specifying the keys of the row to locate.
Syntax
This is the syntax for this function:
=GILOOKUP(Connection, Name, Column, Keys)
Parameters
This function has the following Parameters:
Parameter | Required/Optional | Description |
Connection | Required | The name of the connection, as specified in the Connection Manager |
Name | Required | The name of the Generic Inquiry |
Column | Required | The specific field to be returned from the inquiry data |
Keys | Required | One or more Key(s) to be used to filter the data |
Additional Notes
⚠ For each Generic Inquiry that you use with the GILOOKUP function, you will need to explicitly specify the inquiry's key columns in the Generic Inquiries Options section of the Velixo Options window.
Example
=GILOOKUP("Demo", "AR-Invoices and Memos", "Status", "002263", "Overdue Charge")Description
Assuming that Generic Inquiry Key Fields options for the AR-Invoices and Memos are configured as:
This function call returns the Status field for the record in the database where the ReferenceNbr field is 002263 and the Type field is Overdue Charge.
Result:
Closed
Applies to
GI Module