SI.EXPANDOBJECTRANGE
Created by Damien Zwillinger, Modified on Mon, 19 Aug, 2024 at 5:17 PM by Harry Lewis
Applies to:
- Velixo NX
- Sage Intacct
The SI.EXPANDOBJECTRANGE function returns the sorted names of objects defined with Sage Intacct.
TABLE OF CONTENTS
Syntax
SI.EXPANDOBJECTRANGE (ConnectionName, Range)Parameters
The SI.EXPANDOBJECTRANGE function uses the following parameters:
Parameter | Required/Optional | Description |
Connection | Required | The name of the connection as configured in the Connection Manager |
| Range* | Optional | A range filter specifying the Object names to be displayed. |
Examples
Example 1 - all objects
SI.EXPANDOBJECTRANGE("Sage")Description
Returns all object names defined within Sage Intacct
Result
Example 2 - objects staring with a particular name
SI.EXPANDOBJECTRANGE("Sage","VENDOR?")Description
Returns all object names beginning with the word "Vendor" (not case sensitive)
Result
Example 3 - objects starting with certain letters
SI.EXPANDOBJECTRANGE("Sage","F?;J?")Description
Returns all object names beginning with either the letter F or the letter J
Result
(a cell reference has been used for a parameter in this example)
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article