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.
Please enter the password.
Submit

Change Nickname

Current Nickname:
Submit

Apply New License

License Detail

Please complete this required field.

  • Ultipa Graph V4

Standalone

Please complete this required field.

Please complete this required field.

The MAC address of the server you want to deploy.

Please complete this required field.

Please complete this required field.

Cancel
Apply
ID
Product
Status
Cores
Applied Validity Period(days)
Effective Date
Excpired Date
Mac Address
Apply Comment
Review Comment
Close
Profile
  • Full Name:
  • Phone:
  • Company:
  • Company Email:
  • Country:
  • Language:
Change Password
Apply

You have no license application record.

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

Not having one? Apply now! >>>

Product Created On ID Amount (USD) Invoice
Product Created On ID Amount (USD) Invoice

No Invoice

v5.0
Search
    English
    v5.0

      FOR

      Overview

      The FOR statement unnests a list into individual records and expands the working table accordingly.

      <for statement> ::= 
        "FOR" <binding variable> "IN" <list value expression> [ <ordinality or offset> ]
      
      <ordinality or offset> ::= 
        "WITH" { "ORDINALITY" | "OFFSET" } <binding variable>
      

      Details

      • The <ordinality or offset> defines a variable to track the position of elements in the list:
        • ORDINALITY provides the ordinal position of each element, i.e., 1, 2, 3,....
        • OFFSET provides the zero-based position of each element, i.e., 0, 1, 2, ...
      • The name of the <binding variable> in <ordinality or offset> must differ from the <binding variable> placed right after FOR.

      Unnesting a Simple List

      FOR item IN [1,1,2,3,null]
      RETURN item
      

      Result:

      item
      1
      1
      2
      3
      null

      FOR item IN [[1,2], [2,3,5]]
      RETURN item
      

      Result:

      item
      [1,2]
      [2,3,5]

      Unnesting a Variable

      LET user = "Alex"
      LET interests = ["tennis", "violin"]
      FOR interest IN interests
      RETURN user, interest
      

      Result:

      user interest
      Alex tennis
      Alex violin

      In this query, the FOR statement unnests the list contained in the interests column of the working table into two records. Consequently, the corresponding record in the user column is duplicated to two records as well.

      Unnesting a Group Variable

      CREATE GRAPH myGraph { 
        NODE Card (),
        EDGE Transfers ()-[{label string}]->()
      } PARTITION BY HASH(Crc32) SHARDS [1]
      

      INSERT (c1:Card {_id: 'C1'}),
        	   (c2:Card {_id: 'C2'}),
        	   (c3:Card {_id: 'C3'}),
        	   (c4:Card {_id: 'C4'}),
        	   (c5:Card {_id: 'C5'}),
             (c1)-[:Transfers {label: 'normal'}]->(c2),
             (c1)-[:Transfers {label: 'abnormal'}]->(c5),
             (c5)-[:Transfers {label: 'normal'}]->(c2),
             (c5)-[:Transfers {label: 'abnormal'}]->(c4),
             (c2)-[:Transfers {label: 'normal'}]->(c3),
             (c4)-[:Transfers {label: 'normal'}]->(c3)
      

      To retrieve one shortest path between C1 and C3, and return the label values on edges in the path:

      MATCH SHORTEST 1 ({_id: "C1"})-[trans:Transfers]-{1,6}({_id: "C3"})
      FOR tran IN trans
      RETURN tran.label
      

      Result:

      tran.label
      normal
      normal

      In this query, the variable trans, declared in a quantified path, holds a group degree of reference when used outside the path pattern. To convert it to a singleton degree of reference, you can use the FOR statement to unnest it.

      WITH ORDINALITY

      To collect elements in even positions from a list to a new list:

      FOR item in ["a", "b", "c", "d"] WITH ORDINALITY index // index starts from 1
      FILTER index %2 = 0
      RETURN collect_list(item)
      

      Result:

      collect_list(item)
      ["b","d"]

      WITH OFFSET

      To return the second element in a list:

      FOR item in ["a", "b", "c", "d"] WITH OFFSET index // index starts from 0
      FILTER index = 1
      RETURN item
      

      Result:

      item
      b
      Please complete the following information to download this book
      *
      公司名称不能为空
      *
      公司邮箱必须填写
      *
      你的名字必须填写
      *
      你的电话必须填写