QPR ProcessAnalyzer Expressions

From QPR ProcessAnalyzer Wiki
Jump to navigation Jump to search

QPR ProcessAnalyzer expression language is a versatile query engine for all the QPR ProcessAnalyzer data and models. The expression language can perform variety of calculation operations, such as aggregations, dimensioning and following relations between objects.

Expression and Evaluation Context

An expression is a text to be evaluated and it has a result. Result can be any of the supported object types or empty. An expression may consist of multiple expressions, called sub-expressions.

Expression evaluation is always performed within some context. This context and its type define what functionalities are available. The current context is used by default in the expressions, so whenever a function or property is called, functions and properties accessible in the current context are searched first. If function or property is not found in the current context, then more generic context is used. Error is returned if the requested functionality is not available in the current context or in a generic context. Current context can be accessed explicitly by using syntax _ (underscore).

Expression Chaining and Hierarchies using . and :

Expressions can be chained together two ways:

  • Contextless chaining: When . character is used to chain expressions, the resulting objects will not have context information.
  • Hierarchical chaining: When : character is used to chain expressions, only the result of the whole chained expression will consist of hierarchical arrays where all the values in the first expression (=context object) will be bound to the arrays those values generated. If the second expression does not return an array, the result will be changed to be an array.

The second expression chained to the first one will be evaluated using the following rules:

  • If the result of the first expression is not an array, the second expression will be evaluated with the result of the first expression as its context object.
  • If the result of the first expression is an array, for every element in the array, the second expression will be evaluated with the array item as its context object. The result of the evaluation will be an array of evaluation results (one for each element in the array).
  • If any of the second expression evaluations returns an array, the resulting object will be an array of arrays. If the first expression evaluation returns a typed array, the result will be hierarchic in a way that first level results are objects that contain the information about the actual object as well as the results generated by the second level expressions.

These rules apply also when chaining more than two expressions together. For example, it is possible to generate three level hierarchy with nodes of type: event log -> case -> event: EventLogById(1).Cases.Events or EventLogById(1):Cases:Events.

Examples:

Contextless chaining: First expression not an array, second expression not an array:
"1".("Number is " + _)
Returns:
"Number is 1"

Contextless chaining: First expression is an array, second expression not an array:
[1,2,3].("Number is " + _)
Returns:
["Number is 1", "Number is 2", "Number is 3"]

Contextless chaining: First expression is an array, second expression is an array:
[1,2,3].["Number is " + _, "" + _ + ". number"]
Returns:
[ ["Number is 1", "1. number"], ["Number is 2", "2. number"], ["Number is 3", "3. number"] ]

Hierarchical chaining: First expression is an array, second expression is an array:
[1,2,3]:["Number is " + _, "" + _ + ". number"]
Returns:
[ HierarchicalArray(1, ["Number is 1", "1. number"]), HierarchicalArray(2, ["Number is 2", "2. number"]), HierarchicalArray(3, ["Number is 3", "3. number"]) ]

  • Hierarchical arrays: Whenever traversing a relation in expression language using hierarchical chaining operator ':' for chaining expressions, a hierarchical array will be returned. It is an object which behaves just like a normal array except it stores also context/root/key/label object which usually represents the object from which the array originated from, for example the original case object when querying events of a case.
  • Hierarchical objects: Arrays where at least one object in the array is itself an array is considered to be a hierarchical object. Hierarchical arrays are treated in similar way as normal arrays in hierarchical objects.
  • Depth of a hierarchical object is the number of inner arrays that there are in the object, i.e. how deep is the hierarchy.
  • Level in hierarchical object consists of all the nodes that are at specific depth in object's array hierarchy. 0 is the level at the root of the object, consisting only of the object itself as single item. Levels increase when moving towards leaves.
  • Leaf level is a level that doesn't have any sub levels.

Basic syntax and operators

Several expressions can be separated using semicolon (;). Example:

Let("var1", 2);Let("var2", 3);var1+var2;

Returns: 5

Expression can contain linebreaks without affecting the result. Example:

Let("var1", 2);
Let("var2", 3);
var1+var2;

Returns: 5

Note that the context where the expressions are used, may not allow linebreaks, such as QPR UI context variables.

Following basic arithmetic and logical operations are available:

  • Addition (+) can be performed on numeric types, strings (concatenate two strings) and TimeSpans (addition of two TimeSpans).
  • Subtraction (-) can be performed on numeric types, DateTimes (calculating TimeSpan between two DateTimes) and TimeSpans (difference between two TimeSpans).
  • Multiplication (*) can be performed on numeric types, and between a TimeSpan and a numeric type (multiplying TimeSpan by number which results in TimeSpan),
  • Division (/) can be performed on numeric types, between a TimeSpan and a numeric type (dividing a TimeSpan where TimeSpan must be the left hand side operand).
  • Remainder (%): can be performed on numeric types.
  • Comparison operators: ==, <, <=, >, >=, !=.
  • Logical operands: && (AND), || (OR), ! (NOT)

Quick syntax for condition statement: condition ? trueValue : falseValue. Example:

var1==4 ? "Value is 4" : "Value is other than 4"

Literals

Literals (i.e. static values defined in the expressions) can be written as follows:

Data type Examples
number
  • 123456
  • -1234
  • 0
  • 123.456
  • 0.123
  • -12.34
  • 1.5675E4
  • 35E-6
boolean
  • true
  • false
string
  • "Hello world!"
  • ""
  • "Characters to escape: \" and \\"
  • "Line 1\nLine2"

In string literals, characters " (double quote) and \ (backslash) need to be escaped using the \ (backslash) character. Linebreaks can be added with \n and tabulator with \t. Unicode characters can be added with \uXXXX where the last four characters are the unicode character code, e.g. \u001f.

For writing date and timespan value literals, use the DateTime and TimeSpan functions.

Arrays

Arrays (sequence of items) can be created either using the Array function or brackets (see the examples below).

Examples:

Array(1, 2, 3)
Returns: An array having three elements which are 1, 2 and 3.

[1, 2, 3]
Returns: Same as the previous example.

["Dallas", "New York", "Los Angeles"]
Returns: Array of strings (region names).

Array()
Returns: An empty array.

Lookup operator

Lookup operator (brackets after an array) is used to get one or several items from an array. The loopup expression (the expression inside brackets) defines either:

  • a single integer, which fetches a single item in the array, or
  • an array of integers: fetches multiple items in the array.

Note that the indexes start from the zero. Note also that using an index which is not in the array will throw an exception.

The lookup expression is evaluated in the context of the array where items are to be fetched.

Examples:

[1, 2, 3, 4][1]
Returns: 2

[1, 2, 3, 4][Count(_) - 1]
Returns: 4

["a", "b", "c", "d"][[0, Count(_) - 1]]
Returns: ["a", "d"]

[[1, 2], 3, [4, [5, 6]]][2][1][0]
Returns: 5

Null conditional operator

The null conditional operator (? character) is useful in chaining operations where there might appear null values in the middle of the chain. If not handled correctly, e.g. trying to get a property from an object which is actually null, will throw an exception.

The null conditional operator works as follows: If the result of the first expression is a null value, the result of the chaining operation is that value. For example the following expression throws an exception if StartTime is null:

StartTime.Truncate("month")

The following expression takes into account the null situation, and the expression return null if StartTime is null:

StartTime?.Truncate("month")

The null conditional operator is faster to calculate and syntax is more concise than using if condition.

In the null conditional operator, if the result of the first expression is an array or a hierarchical array, the chaining operator does not chain null values in that array. Null conditional chaining can be applied to both contextless and hierarchical chaining operations by prefixing the chaining operator with ? -character.

Examples:

null?.(_ + 1)
Returns: null

[1, null, 3]?.(_ + 1)
Returns: [2, null, 4]

StartTime?.Truncate("month")
Returns: null (if StartTime is null).

[1, _remove, 3]?.(_ + 1)
Returns: [2, 4]

[1, null, 3]?:(_ + 1)
Returns: [1: [2], null, 3: [4]]

Also a null conditional lookup can be applied to a lookup operation by prefixing the lookup operator with ? character. When null conditional chaining is used, if the root element is an atomic null value, the result of the lookup operation is null.

Examples:

null?[3]
Returns: null

[[1, 2], null, [3]].(_?[0])
Returns: [1, null, 3]

Null coalescing operator

The null coalescing operator (?? characters) can be used to convert null values to something else. The null coalescing operator works as follows:

  • If the left-hand side expression is null, the right-hand side value is returned.
  • If the left-hand side expression is not null, the left-hand side value is returned.

The null coalescing operator combined with the _remove operator is a handy way to remove null values from an array (see the examples below).

Examples:

null ?? "foo"
Returns: "foo"

1 ?? "foo"
Returns: 1

[1, null, 3].(_ ?? "foo")
Returns: [1, "foo", 3]

[1, null, 3].(_ ?? _remove)
Returns: [1, 3]

[1, null, 3]:(_ ?? _remove)
Returns: [1: [1], 3: [3]]

Hierarchical object as key-value pair collection

Special JSON style of formating can be used to express hierarchical objects used for key-value pair collections. These can be used to pass named settings to functions supporting this, e.g. conformance checking functions.

Example:

In the following example, the second parameter of the IsConformant function is a hierarchical objects used as key-value pair collection:
EventLog.Cases:IsConformant(myDesignModel, ["IgnoreEventTypesMissingInModel": false, "IgnoreIncompleteCases": true])

See Also