SI.EXPANDPROJECTRANGE

Created by Damien Zwillinger, Modified on Tue, 21 Nov, 2023 at 8:01 PM by Harry Lewis

Applies to:

  • Velixo NX
  • Sage Intacct


The SI.EXPANDPROJECTRANGE function returns an array containing one or more Project IDs (based on the specified range). 

 

Syntax

SI.EXPANDPROJECTRANGE(ConnectionName, ProjectRange, ProjectType, IncludeInactive)

 

 

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

ProjectRange

Optional

A range filtering specifying the projects to be displayed.

ProjectType

Optional

1 - include projects both with and without children (default)

2 - include only "parent" projects (with at least one child project)

3 - include only "leaf" projects (those without any child projects)

IncludeInactive

Optional

True (default) or False

Determines whether or not to include entries with a Status field set to Inactive in the results.

(available in version 2023.8 and higher


More info about Status

 

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

 

 

Example #4

Assuming the following configuration within Sage Intacct:

 

 

=SI.EXPANDPROJECTRANGE("Sage",,2,FALSE)

 

Description

Returns the Project IDs for all active parent projects.

 

Results

(note that the ID for the only other parent project - 10000 - is not included)

 


About Project Statuses


Please note that Sage Intacct tracks two separate status values for each project.


  • Status - for tracking whether a project is currently Active or Inactive:


and

  • Project Status - for tracking additional details about the projects.


The IncludeInactive parameter of the SI.EXPANDPROJECTRANGE function references the STATUS (active/inactive) field (not the Project Status field).



 

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 at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article