Overview
The ACU.EXPANDOBJECTRANGE function returns the sorted names of DAC objects matching the search criterion, defined within Acumatica.
Syntax
=ACU.EXPANDOBJECTRANGE(
ConnectionName,
Object,
)
Arguments
|
Argument |
Required/Optional |
Description |
|
|
Optional |
Provide one of the following values:
OR Omit the argument to return results for all compatible connections with default aggregation settings. |
|
|
Optional |
A search expression for filtering objects, uses Velixo filtering techniques. If not specified, returns all objects and navigation properties (used for querying related objects). To query available fields from related objects, create another ACU.EXPANDOBJECTRANGE formula that uses the related object’s navigation property as the |
Output
The function returns available fields for the queried object, and a list of navigational properties for related objects (returned at the bottom of the list).
Examples
Return all objects
=ACU.EXPANDOBJECTRANGE(
"Acumatica"
)
Description: Returns a list of objects available for the Acumatica connection.
Result:
Return objects containing a string
=ACU.EXPANDOBJECTRANGE(
"Acumatica",
"Account?"
)
Description: Returns a list of objects available for the Acumatica connection, beginning with the string Account.
Result:
Return fields from a related object
-
First, use the main object in the
Objectargument, for example:=ACU.OBJECTDEFINITION(,"PX.Objects.AP.LocationAPPaymentInfo")The formula will return a list of available fields (at the top of the list), available related objects (at the bottom of the list), and their navigational properties (in the
Typecolumn):
-
Create another ACU.OBJECTDEFINITION formula with the navigation property as the
Objectargument, to retrieve a list of available fields for the related object, for example:=ACU.OBJECTDEFINITION(,"PX.Objects.CR.Contact")