Filtering GI data on your computer instead of the server (Classic)

Created by Damien Zwillinger, Modified on Wed, 10 Apr 2024 at 06:57 PM by Harry Lewis

Applies to:

  • Velixo Classic
  • Acumatica, MYOB Advanced, Cegid


By default, the filter expressions you specify in GI / GILOOKUPF Velixo functions are handled by your ERP, so as to reduce the amount of data that needs to be transferred between your ERP and your report.


Performing filtering through OData is very fast; however, it does have some limitations. 


For example: 

If your filtering efforts encounter one or more of these limitations, you may want to force Velixo to do the filtering, instead.

As a rule of thumb, only use this option as a last resort.


The reason is that if your inquiry could return a very large dataset without a filter (as is the case with invoices or GL transaction details), enabling client-side filtering can have severe performance implications with massive amounts of data transferred between your ERP and Velixo. 

Client-side filtering may also help if you need to pull data from the same generic inquiry using multiple different OData filter expressions, all in the same spreadsheet. 


Keep in mind though: lookups by e.g. document reference number, or a customer name may be much more performant using GILOOKUPF, because it allows you to keep at least some of the filtering on the server.

From the Velixo ribbon in Excel, select Options, then the three-dot kabob menu on the specific GI, and then Edit:


Then check the box for Always load the entire Generic Inquiry and filter the data locally:

This will do exactly that: the entire data set from the inquiry will be downloaded and then Velixo will do the filtering.


You can now refresh your report and the filtering of your GI() function(s) will be handled within Excel by Velixo.

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 atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article