Change Password

Input error
Input error
Input error
Submit

Change Nickname

Current Nickname:
Submit
Search
v4.0
    v4.0

    sum() | Summation

    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)
    
    Please complete the following information to download this book
    *
    公司名称不能为空
    *
    公司邮箱必须填写
    *
    你的名字必须填写
    *
    你的电话必须填写
    *
    你的电话必须填写