Null Functions
Example Graph
The following examples run against this graph:
coalesce()
Returns the first non-null value from a list of provided values. It returns null if all values are null.
| Syntax | coalesce(<value1>, <value2>, ...) | ||
| Arguments | Name | Type | Description |
<value1>,<value2>,... | Any | The input values; at least two are required | |
| Return Type | Any | ||
UQLfind().nodes() as n with coalesce(n.score, "N/A") as score return table(n.title, score)
Result:
| n.title | score |
|---|---|
| Optimizing Queries | 9 |
| Efficient Graph Search | 6 |
| Path Patterns | N/A |