apoc.atomic.remove
Syntax |
|
||
Description |
Removes the element at position from the |
||
Input arguments |
Name |
Type |
Description |
|
|
The node or relationship that has a property containing a list. |
|
|
|
The name of the property from which the value will be removed. |
|
|
|
The position in the list to remove the item from. |
|
|
|
The max retry attempts. The default is: |
|
Return arguments |
Name |
Type |
Description |
|
|
The updated node or relationship. |
|
|
|
The name of the updated property. |
|
|
|
The original value on the property. |
|
|
|
The new value on the property. |
Usage examples
The examples in this section are based on the following sample graph:
CREATE (:Person {name:'Tom',age: 40})
CREATE (:Person {name:'Will',age: 35})
CREATE (:Person {name:'David', children: ['Anne','Sam','Paul']})
CREATE (:Person {name:'John', cars: ['Class A','X3','Focus']})
CREATE (:Person {name:'Ryan', salary1:1800, salary2:1500});
The following removes the element X3
, which is at position 1, from the array cars
MATCH (p:Person {name:'John'})
CALL apoc.atomic.remove(p,'cars',1,5)
YIELD oldValue, newValue
RETURN oldValue, newValue;
oldValue | newValue |
---|---|
["Class A", "X3", "Focus"] |
["Class A", "Focus"] |