ACU.EXPANDOBJECTRANGE
Overview
The ACU.EXPANDOBJECTRANGE function returns the sorted names of DAC objects matching the search criterion, defined within Acumatica.
Syntax
CODE
=ACU.EXPANDOBJECTRANGE(
ConnectionName,
Object,
)Arguments
Argument | Required/Optional | Description |
| Required | The name of the connection, as specified in the Connection Manager |
| Optional | A search expression for filtering objects, uses Velixo filtering techniques. If not specified, returns all objects. |
Examples
Return all objects
CODE
=ACU.EXPANDOBJECTRANGE(
"Acumatica"
)Description: Returns a list of objects available for the Acumatica connection.
Result:
Return objects containing a string
CODE
=ACU.EXPANDOBJECTRANGE(
"Acumatica",
"Account?"
)Description: Returns a list of objects available for the Acumatica connection, beginning with the string Account.
Result:
