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)