QPR Knowledge Base 2017.1



Previous topic Next topic No directory for this topic  


Previous topic Next topic Topic directory requires JavaScript Mail us feedback on this topic!  

Revision history:

Introduced in QPR 8.1

Last changed in QPR 2012


Set statuses for one or more elements/periods/series.




SCModel.SetStatuses(ElementId, Statuses)




ElementId: Integer. If this is 0, the Statuses array must contain columns for measure identifier and scorecard identifier.

Statuses: Two-dimensional array with either 3 or 5 columns depending on the value of ElementId. The array can contain one or more rows with the following format:

Measure identifier. String. Supplied only if ElementId = 0.

Scorecard identifier. String. Supplied only if ElementId = 0.

Series identifier. String. Identifier of the series for which status is set.

Date. String. Date to determine for which period the status is set. You can define the date in three ways: By period index, by period name, or by date. To define a period index, prefix the value with a #, i.e. "#5" would make the value to be set for the fifth period. To define the target period by the period name, prefix the value with a $, e.g. "$Q3/2009". To define the period by a date, input the date without any special control characters. Date strings are first interpreted using the system locale formatting settings, and in the case that fails, using the ISO standard settings (yyyy-mm-dd hh:mm:ss).

Status: String. Name of the status to set. If this is empty, the existing status is cleared.


Required Rights:


Administrator or Model Administrator rights to the SCModel.


Return Values:

Below are listed the return values that this function can return:












Example Procedure:


iRet = SCModel.SetStatuses(id, arrStatuses)