QPR Reporting Expression Language - Revision history

Ollvihe at 11:20, 25 June 2024

2024-06-25T11:20:23Z

2024-06-04T19:56:54Z

QPR Reporting Expression Engine

2020-05-22T12:01:33Z

2020-05-22T11:56:59Z

2020-01-19T06:52:10Z

2019-06-05T11:42:12Z

Added example of the "Where (dataset)" expression

2019-04-09T20:47:44Z

Dataset Functions

2018-12-12T11:44:36Z

Added an example of how to use the Maximum expression

2018-12-01T15:54:25Z

2018-08-29T14:13:34Z

Other Functions

@@ Line 574: / Line 574: @@
 * attribute (string)
 * options (string)
-||QPR Web Service’s GetAttributeAsString operation, see http://kb.qpr.com/qpr2017-1/index.html?getattributeasstring.htm.
+||QPR Web Service’s GetAttributeAsString operation, see http://kb.qpr.com/qpr2023-1/index.html?getattributeasstring.htm.
 |- style="vertical-align:top;"
 ||GetAttributes (string array)||
@@ Line 591: / Line 591: @@
 * view (string)
 * options (string)
-||QPR Web Service’s GetPortalUrl operation, see http://kb.qpr.com/qpr2017-1/index.html?getportalurl.htm.
+||QPR Web Service’s GetPortalUrl operation, see http://kb.qpr.com/qpr2023-1/index.html?getportalurl.htm.
 |- style="vertical-align:top;"
 ||LatestValuePeriod (string)||
@@ Line 1,013: / Line 1,013: @@
 * attribute (string)
 * options (string)
-||Gets an embedded file from QPR system as byte array using QPR Web Service’s '''GetBinaryData''' operation with provided parameters. More information http://kb.qpr.com/qpr2017-1/index.html?getbinarydata.htm.
+||Gets an embedded file from QPR system as byte array using QPR Web Service’s '''GetBinaryData''' operation with provided parameters. More information http://kb.qpr.com/qpr2023-1/index.html?getbinarydata.htm.
 |- style="vertical-align:top;"
 ||QprGraphData (byte array)||

@@ Line 1,515: / Line 1,515: @@
 |sessionId
 ||string
-||QPR Web Service’s session id. Used only if '''authenticationmode=passedsession.'''
+||QPR Web Service’s session id. Used only if '''authenticationmode=commonqprauthentication.'''
 |- style="vertical-align:top;"
 | expressionSet || string[] || List of expressions.

@@ Line 925: / Line 925: @@
 ||Filters out all rows in the dataset where expression is evaluated as false. The expression has all columns as arguments. Also, there is an argument rowordernumber, which is the row order number starting from 0.
 Example:
 B=Where([A], 'length(actual)<>0'). This returns all rows of the dataset [A] where the length of the value in column "actual" is 0 (= the column has a null value).
 |}

@@ Line 581: / Line 581: @@
 * options (string)
 ||Returns multiple attributes of a single object as an array. Attributes are defined as comma separated. Based on QPR Web Service’s QueryObjects operation.
 |- style="vertical-align:top;"
 ||GetPortalUrl (string)||

@@ Line 859: / Line 859: @@
 This function cannot be used for textual series.
-Example:
+Examples:
-MetricsMeasureValues(Array('SC.1938773693.159'), Array('ACT_AVG'), Array('value', 'prettyvalue'), Array('valueColumn', 'prettyvalueColumn'))
+Single measure: var1=MetricsMeasureValues(Array('SC.1938773693.159'), Array('ACT_AVG'), Array('value', 'prettyvalue'), Array('valueColumn', 'prettyvalueColumn')).
 |- style="vertical-align:top;"
 ||RemoveColumns (dataset)||

@@ Line 916: / Line 916: @@
 * expression (string)
 ||Filters out all rows in the dataset where expression is evaluated as false. The expression has all columns as arguments. Also, there is an argument rowordernumber, which is the row order number starting from 0.
 |}

@@ Line 849: / Line 849: @@
 * value attribute names (string array)
 * value column names (string array)
-||Returns Metrics measure values as a dataset from multiple periods (dataset rows) and multiple series or measures (dataset columns). Each period id will have a separate row, i.e. data from different measures are combines in a same row if the measures have a same period level.
+||Returns Metrics measure values as a dataset from multiple periods (returned as dataset rows) and multiple series or measures (returned as dataset columns). Each period id will have a separate row, i.e. data from different measures are combined in a same row if the measures have a same period level.
 Element id’s, series symbols and value column names in the result dataset are provided as separate arrays. If element id's, series symbols and value attribute names arrays have less items than in the value column names, the last item is used as a rest of the items.
 The result dataset will have '''columns, periodid, periodname, startdate''' and '''enddate'''.
 Valid value attribute names are '''value''' and '''prettyvalue''' (these are from QPR Web Service’s values attribute). Data in result dataset are strings, and in case "value" attribute is used, they can be converted to numeric.
 Example:

@@ Line 358: / Line 358: @@
 * array
 ||Returns the largest number in the provided array.
 |- style="vertical-align:top;"
 ||OnlyValue (object)||

@@ Line 1,016: / Line 1,016: @@
 * renderingdelay (int)
 * timeout (int)
-||More information in chapter [[Reporting Add-on#WebpageAsImage Function|WebpageAsImage Function]].
+||More information in chapter [[QPR Reporting Add-on#WebpageAsImage Function|WebpageAsImage Function]].
 |}

@@ Line 1,050: / Line 1,050: @@
 ||ApplicationSetting (string)||
 * setting name (string)
 ||
-Returns application setting value by its name. Settings are defined in the web.config file of QPR Reporting Add-on.
+Returns application setting value by its name. Settings are defined in the web.config file of QPR Reporting Add-on (located by default in the server in C:\inetpub\wwwroot\QPRWebServicesExtensions\web.config). The default value is used, if the setting is not found.
 |-
 ||Coalesce (object)||