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

CODE

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

Arguments

Argument	Required/Optional	Description
`ConnectionName`	Required	The name of the connection, as specified in the Connection Manager
`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

CODE

=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: