SI.EXPANDTASKRANGE

Created by Damien Zwillinger, Modified on Thu, 5 Oct, 2023 at 5:49 PM by Gabriel Michaud

Applies to:

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

TABLE OF CONTENTS

Syntax

SI.EXPANDTASKRANGE(ConnectionName, ProjectRange, TaskRange, TaskType, IncludeProjects)

The SI. EXPANDTASKRANGE function uses the following parameters:

Parameter	Required/ Optional	Description
ConnectionName	Required	The name of the connection as configured in the Connection Manager
ProjectRange	Optional	The range of project codes to examine to find the task codes to include in the results. See our article on including multiple parameter values
TaskRange	Optional	The range of task codes to include in the results. See our article on including multiple parameter values
TaskType	Optional	The type of task(s) to be displayed: 1 (Default) - All types of tasks 2 - Parent tasks only. Includes tasks which have at least one leaf task 3 - Leaf tasks only. Includes tasks which have no parent ID defined
IncludeProjects	Optional	True or False (Default) Determines whether or not project IDs are included as a separate column in the results

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

Description

Returns all task codes for all projects.

Result

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

Description

Returns all task codes used within projects 10000 through 10025.

Results

=SI.EXPANDACCOUNTRANGE("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:

=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

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

Description

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

Results