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.3
Search
    中文EN
    v4.3

      coalesce()

      Function coalesce() returns the left-most non null value from multiple (≥2) values, or returns null if all values are null.

      When multiple values are of different data structures, data conversion might be triggered to guarantee a consistent data type in the final data stream.

      Occasions when null value is produced: properties not provided when inserting data, properties created after data is inserted, calling a property that is not existent.

      Arguments:

      • Any value <any>
      • ...

      Returns:

      • Result <any>

      Sample graph: (to be used for the following examples)

      Run below UQLs one by one in an empty graphset to create graph data:
      create().node_property(@default, "name").node_property(@default, "try1", int32).node_property(@default, "try2", int32).node_property(@default, "try3", int32)
      insert().into(@default).nodes([{name:"Jason", try1:84}, {name:"Alice", try1:55, try2:79}, {name:"Lina"}, {name:"Eric", try1:39, try2:46, try3:61}, {name:"Pepe", try1:89}])
      

      Comman Usage

      Example: Return the score of the last test that each student takes, knowing that each student has three chances, and retesting is allowed only if the previous one failed. Return -1 if a student does not give any try.

      find().nodes() as n
      return table(n.name, coalesce(n.try3, n.try2, n.try1, -1))
      

      | n.name | coalesce(n.try3, n.try2, n.try1, -1) |
      |--------|--------------------------------------|
      | Jason  | 84                                   |
      | Alice  | 79                                   |
      | Lina   | -1                                   |
      | Eric   | 61                                   |
      | Pepe   | 89                                   |
      
      Please complete the following information to download this book
      *
      公司名称不能为空
      *
      公司邮箱必须填写
      *
      你的名字必须填写
      *
      你的电话必须填写
      *
      你的电话必须填写