We're trying to propagate a property on nodes with a specific label ("Concept") to connected nodes (with predicate "CONTAINS_OBJECT") as a new label, but are struggling to assign the property to a variable within the query. How can this be done assuming there will be multiple "Concept" nodes, with the assumption that no "Concept" nodes will have overlapping connections with other "Concept" nodes.
i.e. The following will never occur, where n0 and n1 are distinct:
(n0:Concept)-[:CONTAINS_OBJECT]->(o:Object)<-[:CONTAINS_OBJECT]-(n1:Concept)
Basically, how should this be done with Cypher?
Disclaimer: We're quite new to Cypher - any and all advice is appreciated.
We have tried a few more restricted queries but have had issues getting variable assignment working there as well.
This query achieved the desired result for a single specified "Concept" node:
MATCH p = (c:Concept{ Name: 'Con0' })-[:CONTAINS_OBJECT]->(END)
FOREACH (n in nodes(p) | SET n:Con0)
The following query was our attempt to bind the "Concept" node's 'Name' property to a variable", but 'p' isn't being assigned in this instance:
MATCH p = (c:Concept{ Name: 'Con0' })-[:CONTAINS_OBJECT]->(END)
WITH c.Name as conceptName
FOREACH (n in nodes(p) | SET n:conceptName)
To simplify the result we're after as much as possible, the end result is that the following two MATCH statements should return the same results for any given "Concept" node:
1)
MATCH (c:Concept{ Name: 'Con0' })-[:CONTAINS_OBJECT]->(o:Object)
2)
MATCH (c:Concept{ Name: 'Con0' })-[:CONTAINS_OBJECT]->(o:Con0)
Looking to build a query along these lines:
MATCH p = (c:Concept)-[:CONTAINS_OBJECT]->(END)
WITH c.Name as conceptName
FOREACH (n in nodes(p) | SET n:conceptName)
For anyone that comes to this post with similar requirements, we eventually came to the following query which got us exactly the result we were after:
call apoc.periodic.commit("MATCH (n:Concept)-[:CONTAINS_OBJECT]->(o:Object)
WITH o, n, replace(n.Name, ' ', '_') as label limit {limit} call
apoc.create.addLabels(o, [label]) yield node
with node
RETURN node",
{limit:100000});
Note that we have < 150 nodes labelled with "Concept", and had 'Name' fields containing spaces which we've replaced with underscores.
Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments