SI.EXPANDTASKRANGE

Overview

The SI.EXPANDTASKRANGE function returns all task IDs within the specified project and/or task ID range.

CODE

=SI.EXPANDTASKRANGE(ConnectionName, Project, Task, TaskType, IncludeProjects)

The SI. EXPANDTASKRANGE function uses the following arguments:

Argument	Required/ Optional	Description
`ConnectionName`	Required	The name of the connection as configured in the Connection Manager
`Project`	Optional	The range of project codes to examine to find the task codes to include in the results. See our article on including multiple argument values
`Task`	Optional	The range of task codes to include in the results. See our article on including multiple argument values
`TaskType`	Optional	The type of task(s) to be displayed: `1` (Default) - All types of tasks `2` - Parent tasks only. Includes tasks defined as a parent task for at least one other task `3` - Leaf tasks only. Includes tasks not defined as a parent task for any other task
`IncludeProjects`	Optional	`TRUE` or `FALSE` (Default) Determines whether or not project IDs are included as a separate column in the results

CODE

=SI.EXPANDTASKRANGE("Sage", "*", "*")

Description
Returns all task codes for all projects.

Result

CODE

=SI.EXPANDTASKRANGE("Sage", "10000:10025")

Description
Returns all task codes used within projects 10000 through 10025.

Results

CODE

=SI.EXPANDTASKRANGE("Sage",,"100:900;-300")

Description
Returns all task codes between 100 and 900 (inclusive) except code 300.

Results

Given this structure defined within Sage Intacct:

CODE

=SI.EXPANDTASKRANGE("Sage","coyr-0017","R3-03???",2)

Description
Returns all Parent task codes beginning with "R3-03" with a Job ID of COYR-0017.

Results

CODE

=SI.EXPANDTASKRANGE("Sage","*",,,TRUE)

Description
Returns all task codes for all projects and includes the project code as the first column of the results.

Results