SI.EXPANDSTANDARDTASKRANGE function

Created by Damien Zwillinger, Modified on Mon, 10 Jun 2024 at 06:45 PM by Harry Lewis

Applies to:

  • Velixo NX
  • Sage Intacct


TABLE OF CONTENTS


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

IncludeInactiveOptionalBoolean (True/False) value determining whether or not Standard Tasks marked as Inactive are included in the results.

Available values:
  • TRUE (Default)
  • FALSE

 


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)

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article