apoc.create.virtual.fromNode
Syntax |
|
||
Description |
Returns a virtual |
||
Arguments |
Name |
Type |
Description |
|
|
The node to generate a virtual node from. |
|
|
|
The properties to copy to the virtual node. |
|
|
|
|
|
Returns |
|
||
Usage Examples
The examples in this section are based on the following graph:
CREATE (a:Account {type: 'checking', ownerName: 'Maria Perez', ownerId: '123456789', accountNumber: 101010101, routingNumber: 10101010, amount: 1000.00, bank: 'Best Bank'});
CREATE (p:Person {name: 'Jane Doe', birthdate: date('1990-01-13'), favoriteColor: 'green', favoriteDessert: 'ice cream', favoriteMusic: 'classical', favoriteBand: 'The Beatles', favoriteVacation: 'beach', favoriteAnimal: 'horse', favoriteBeverage: 'coffee', favoriteFlower: 'lily'});The apoc.create.virtual.fromNode procedure provides a way to only visualize or return data that is needed, hiding any unnecessary or sensitive pieces.
The example below shows how we can use the procedure to return only the non-sensitive properties from the node above:
MATCH (a:Account {accountNumber: 101010101})
RETURN apoc.create.virtual.fromNode(a, ['type','bank']);| account |
|---|
{"type":"checking","bank":"Best Bank"} |
The apoc.create.virtual.fromNode procedure can also be used to simplify nodes with many properties by only displaying ones that are important to the query.
The example below shows an example of this use:
MATCH (p:Person {name: 'Jane Doe'})
RETURN apoc.create.virtual.fromNode(p, ['favoriteColor','favoriteAnimal','favoriteMusic']);| favorites |
|---|
{"favoriteAnimal":"horse","favoriteMusic":"classical","favoriteColor":│ |
"green"} |
Wrapping nodes
By default, this function will change the id of the node to a negative number which is representative of Virtual Nodes.
In order to retain the original id, use the config item { wrapNodeIds: true }.
CREATE (p:Person {name: 'Jane Doe'})
WITH apoc.create.virtual.fromNode(p, ['name'], { wrapNodeIds: true }) AS node
RETURN id(node) AS id;| id |
|---|
1 |