Applies to
⚠️ Velixo NX only
ERP: Sage Intacct
This function applies to Sage Intacct connections only.
Description
The SI.EXPANDPROJECTRANGE function returns an array containing one or more Project IDs (based on the specified range).
Syntax
SI.EXPANDPROJECTRANGE(ConnectionName, Range)
The SI. EXPANDPROJECTRANGE function uses the following parameters:
Parameter | Required/Optional | Description |
ConnectionName | Required | The name of the connection as configured in the Connection Manager |
Range | Optional | A range filtering specifying the projects to be displayed. |
Examples
Example #1
=SI.EXPANDPROJECTRANGE("Sage")
Description
Returns the Project ID for every project in the specified connection.
Results
Example #2
=SI.EXPANDPROJECTRANGE("Sage", "IN???")
Description
Returns all Project IDs starting with "IN".
Results
Example #3
=SI.EXPANDPROJECTRANGE("Sage", "*;-100??")
Description
Returns all Project IDs that do not start with "100".
Results
