SI.EXPANDSTANDARDTASKRANGE
Applies to:
- Velixo NX
- Sage Intacct
The SI.EXPANDSTANDARDTASKRANGE function returns an array of all Standard (as opposed to project-scoped) tasks available in the Standard task catalog within the Sage Intacct Project area:
Syntax
SI.EXPANDSTANDARDTASKRANGE(Connection, Range, IncludeInactive)
Parameters
The SI.EXPANDSTANDARDTASKRANGE function uses the following parameters:
Parameter | Required/Optional | Description |
Connection | Required | The name of the connection as configured in the Connection Manager |
Range | Optional | The range of standard tasks to include in the results. See our article on including multiple parameter values |
| IncludeInactive | Optional | Boolean (True/False) value determining whether or not Standard Tasks marked as Inactive are included in the results. Available values:
|
Examples
Example 1
=SI.EXPANDSTANDARDTASKRANGE("Sage")Description
Returns a list of all standard (as opposed to project-scoped) tasks (cost codes).
Result
Example 2
=SI.EXPANDSTANDARDTASKRANGE("Sage","100:300")Description
Returns all Standard Tasks within the range of 100 through 300 (inclusive).
Result
Example 3
=SI.EXPANDSTANDARDTASKRANGE("Sage","*;-200")Description
Returns all Standard Tasks except code #200
Result
Example 4
=SI.EXPANDSTANDARDTASKRANGE("Sage")Description
Returns all ACTIVE Standard Tasks:
Result
(Inactive task #200 is not included)