Parameters, Value
The summation function calculates the sum of a column of data. It only keeps the data column as well as its homologous columns after aggregation, and it disgards other columns.
Syntax:
- Format: sum(
<column>) - Parameters: see table below
- Value: ATTR ( number, string )
| Name | Category | Specification | Description |
|---|---|---|---|
<column> |
NODE，EDGE，PATH，ATTR，ARRAY，TABLE | / | The column to be calculated |
The value of <column> with different categories in every row:
| Type | Value |
|---|---|
| NODE | Node's UUID in the row |
| EDGE | Edge's UUID in the row |
| PATH | ROW INDEX（starts from 0）in the row |
| ATTR | ATTR's value in the row |
| ARRAY | The value of the 1st element in the array of the row |
| TABLE | ROW INDEX（starts from 0）in the row |
ATTR (Numeric value)
Example: find the outbound 1-step transfer paths from Card CA001, return the sum of the transfer amounts
n({_id == "CA001"}).re({@transfer} as pay).n({@card})
return sum(pay.amount)
ATTR (String)
Example: find the outbound 1-step transfer paths from Card CA001, return the strings converted from payee cards' IDs
n({_id == "CA001"}).re({@transfer}).n({@card} as payee)
return sum(payee._id)