Node Grouping Functions

Node Groupings allow tasks to be worked using an arbitrary grouping of nodes which might be intended, for example, to target the highest grade, or work in a grouped order not specified by the level structure.

GetNodeGroupingKey and TableNodeGroupingKey functions can be used to return the NodeGrouping Key for the current table or a specified table, respectively.

GetNodeGroupingKey

GetNodeGroupingKey(NodeGrouping nodeGrouping)

Retrieves the evaluated node grouping key from the current node's specified Node Grouping.

GetNodeGroupingKey(NodeGrouping nodeGrouping, [Node node])

Retrieves the evaluated node grouping key from the specified node's Node Grouping.

GetNodeGroupingKey(NodeGrouping nodeGrouping, [Node node], [string ValuefError])

Retrieves the evaluated node grouping key from the specified node's Node Grouping or the ValueIfError if an error is encountered.

TableNodeGroupingKey

TableNodeGroupingKey(String table, NodeGrouping nodeGrouping, Node node, [string ValueIfError])

Retrieves the evaluated node grouping key from the specified Table, Node Grouping and Node or the ValueIfError if an error is encountered.

Aggregation

Node Grouping Aggregation functions can be used in expressions to provide various field summaries (for the current table or a specified table) and are listed below:

CountOfGroup

CountOfGroup(NodeGrouping grouping, String groupValue, Field fieldToCount, string ExpectedValue, [float safeValue])

Retrieves the Count of the nodes that match the GroupValue from the current table's NodeGrouping and the ExpectedValue from the Field to count.

e.g. CountOfGroup(A,”B”,C,”D”) → Get the count of nodes that are in the current table, where their value in NodeGrouping A is equal to “B” AND their value for field C, when converted to string, is equal to “D”.

TableCountOfGroup

TableCountOfGroup(String table, NodeGrouping grouping, String groupValue, Field fieldToCount, string ExpectedValue, [float safeValue])

Retrieves the Count of the nodes that match the GroupValue from the specified Table's NodeGrouping and the ExpectedValue from the Field to count.

MaxOfGroup

MaxOfGroup(NodeGrouping grouping, String groupValue, Field fieldToMax, [float safeValue])

Retrieves the Maximum of a Field on all nodes that return the GroupValue from the current table's NodeGrouping.

TableMaxOfGroupBool

TableMaxOfGroupBool(String table, NodeGrouping grouping, String groupValue, String fieldToMax, [float safeValue])

Retrieves the Maximum BooleanValue of a Field on all nodes that return the GroupValue from the specified Table's NodeGrouping.

TableMaxOfGroupDate

TableMaxOfGroupDate(String table, NodeGrouping grouping, String groupValue, String fieldToMax, [float safeValue])

Retrieves the Maximum Date Value of a field on all nodes that return the GroupValue from the specified table's NodeGrouping.

TableMaxOfGroupValue

TableMaxOfGroupValue(String table, NodeGrouping grouping, String groupValue, String fieldToMax, [float safeValue])

Retrieves the Maximum Numeric Value of a field on all nodes that return the GroupValue from the specified table's NodeGrouping.

MinOfGroup

MinOfGroup(NodeGrouping grouping, String groupValue, Field fieldToMin, [float safeValue])

Retrieves the Minimum of a Field on all nodes that return the GroupValue from the current table's NodeGrouping.

TableMinOfGroupBool

TableMinOfGroupBool(String table, String grouping, String groupValue, String fieldToMin, [float safeValue])

Retrieves the Minimum Boolean Value of a field on all nodes that return the GroupValue from the specified table's NodeGrouping.

TableMinOfGroupDate

Retrieves the Minimum Date Value of a field on all nodes that return the GroupValue from the specified table's NodeGrouping.

TableMinOfGroupDate(String table, NodeGrouping grouping, String groupValue, String fieldToMin, [float safeValue])

TableMinOfGroupValue

TableMinOfGroupValue(String table, NodeGrouping grouping, String groupValue, String fieldToMin, [float safeValue])

Retrieves the Minimum Numeric Value of a field on all nodes that return the GroupValue from the specified table's NodeGrouping.

SumOfGroup

SumOfGroup(NodeGrouping grouping, String groupValue, Field fieldToSum, [float safeValue])

Retrieves the Sum of a Field on all nodes that return the GroupValue from the current table's NodeGrouping.

SumProductOfGroup

SumProductOfGroup(NodeGrouping grouping, String groupValue, Field field1, Field field2, [float safeValue])

Retrieves the Sum Product of two specific fields on all nodes that return the GroupValue from the current table's NodeGrouping.

e.g. (NodeA/Field1 * NodeA/Field2) + (NodeB/Field1 * NodeB/Field2), etc.

TableSumOfGroup

TableSumOfGroup(String table, NodeGrouping grouping, String groupValue, String field, [float safeValue])

Retrieves the Sum of a Field on all nodes that return the GroupValue from the specified Table's NodeGrouping.

TableSumProductOfGroup

TableSumProductOfGroup(String table, NodeGrouping grouping, String groupValue, String field1, String field2, [float safeValue])

Retrieves the Sum Product of two fields on all nodes that return the GroupValue from the specified Table's NodeGrouping.