ACU.QUERYFILTER

Overview

The ACU.QUERYFILTER function returns a string that can be used as input for the Filter parameter in the ACU.QUERY function.

Syntax

=ACU.QUERYFILTER(
  ConnectionName, 
  Object, 
  CaseInsensitive,
  Column, 
  Criteria, 
  AnotherColumnOrCriteria1,
  AnotherColumnOrCriteria2,
  …
)

Arguments

Argument	Required/Optional	Description
`ConnectionName`	Optional	Provide one of the following values: Connection name as defined in Connection Manager. Velixo range expression defining a set of connection names. An array of settings as described in the Multiple connections per formula article. We recommend using the VX.SETTINGS function to construct the array. This function does not support the multiple connection functionality. If the argument is omitted, and there exists a connection that is compatible with the formula, this connection will be used.
`Object`	Required	Acumatica Data Access Class (DAC) name. For instance, `GLAccount` or `PMCostProjection`. Please use ACU.EXPANDOBJECTRANGE to explore available objects.
`CaseInsensitive`	Optional	Produce a filter insensitive to the case of text values. Possible values: `TRUE` and `FALSE` Default value: `FALSE`
`Column`	Required	Name of the object field you wish to filter. Please use the ACU.OBJECTDEFINITION function to explore available object fields.
`Criteria`	Required	A criterion or set of criteria that you want your filtered results to meet. Criteria can be one of the following: a value – the parameter should be equal to the value an Excel comparison operator (`<>`, `>`, `<`, `=`, `>=`, `<=`), followed by a value The parameter can be a single value, an array of values, or a range of cells. If the parameter is an array or a range of cells, each value will be considered an alternative and joined via a logical `OR` as part of a bracketed group.
`AnotherColumnOrCriteria1`	Optional	Second object used for filtering.
`AnotherColumnOrCriteria2`	Optional	Criterion for the second filter.
…

Output

The function returns a string containing a valid filter, ready for use with the ACU.QUERY function.

Example

=ACU.QUERYFILTER(
  "Acumatica",
  "GLBatch",
  ,
  "CREATEDDATETIME",
  ">= 2025-01-01",
  "APPROVED",
  "= true",
  "BRANCHID",
  "= 16"
)

Description:

A filter for the GLBatch object; approved batches created for branch 16 on or after 1 Jan 2025, approved only.

Below, you can see the filter used with the ACU.QUERY function: