Change Password

Please enter the password.
Please enter the password. Between 8-64 characters. Not identical to your email address. Contain at least 3 of uppercase, lowercase, numbers, and special characters (such as @*&#).
Please enter the password.
Submit

Change Nickname

Current Nickname:
Submit

Certifications

Certificate Issued at Valid until Serial No. File
Serial No. Valid until File

Not having one? Apply now! >>>

Invoice

ProductName CreateTime ID Price File
ProductName CreateTime ID Price File
v4.0
Search
    中文EN
    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
      *
      公司名称不能为空
      *
      公司邮箱必须填写
      *
      你的名字必须填写
      *
      你的电话必须填写
      *
      你的电话必须填写