Velixo NX Release notes 2023 Archive

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).