This feature requires Microsoft 365 when used with Velixo 5, or (experimentally) Excel 2010 or higher when used with Velixo 6 or higher. For prerequisites and an overview of Generic Inquiries, see Introduction to Generic Inquiries.

Description

The GI function returns the content of a generic inquiry.

Syntax

This is the syntax for this function:

=GI(Connection, Name, Filter, Select, IncludeHeader)

Parameters

This function has these 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.

Filter

Optional

The conditions that determine which records should be selected from the inquiry.

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

Select

Optional

Comma-separated list of columns to be included in the resulting dataset. If this parameter is empty, all the columns from the generic inquiry will be returned.

IncludeHeader

Optional

TRUE or FALSE, indicating if should column headers be included in the dataset.

Example

=GI("Demo", "VelixoReportsPro-Projects", A1, "ProjectCD, Description", FALSE)

Description: Returns the project code and the description of records returned by the VelixoReportsPro-Projects generic inquiry, which match the filter conditions specified in cell A1. FALSE as the last parameter specifies that no column headers should be returned.

Result:

Screen_Shot_2020-06-10_at_17.59.46.png

Configuration

For configuration details, see Generic Inquiries Options.

Accommodating GI Filters in Acumatica

Acumatica Generic Inquiries can include pre-defined parameters which are used within Acumatica to filter the results of the inquiry:

e.g.,

gi_extra_filters2.png

Acumatica's OData interface (used by Velixo Reports for querying the GI) does not support this type of filtering. To be compatible with your Velixo report, you would need to modify your GI by either (a) removing the parameters or (b) making them optional by ensuring that the conditions in your GI will return the full dataset when the parameters are not specified.

Filtering Large Generic Inquiry Datasets

If you experience either long load times (especially with Velixo Reports) or a persistent #BUSY! message (using Velixo NX on Mac or Excel Online) for inquiries with a very large result set [e.g. GL transactions or invoices], make sure to always supply a GIFILTER filter when using the other GI-related functions with such inquiries.

In Velixo Reports for Windows, if you're using "always load the entire Generic Inquiry" to enable more advanced OData syntax, consider disabling it for larger inquiries and rewriting your filters so that they do not involve ODATA functions unsupported by Acumatica [such as startswith() or toupper()]. Applying your filters on the server [before downloading the data] can significantly reduce the load time.

Applies to

GI Module

Did this answer your question?