Cypher Query to return all nodes and relationships under a tree

[Christopher Hydak]

My graph is constructed with separate trees, which indicate customers.  Almost all nodes and relationships under that customer should not connect to anything outside of the tree.  Other than recursively calling neo4j for each node in the tree, is there a good cypher query to find the nodes and relationships under the tree starting at the root of the tree?  The depth is unknown at this time, but can be (for now) assumed to be < 15.  There are about 120 relationship types, and these are variable, so we can't explicitly list those.  There are some (like 3 exceptions) that I would like to exclude based upon the relationship name.

Thanks,

Christopher

[Wes Freeman]

How do you want them to be returned. Is this good enough?

MATCH (root:Customer)-[r*]->(child)

WHERE root.id = {custId}
   AND NOT type(r) IN ["exception1", "exception2", "exception3"]
RETURN *

Wes

--
You received this message because you are subscribed to the Google Groups "Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email to neo4j+un...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

[Christopher Hydak]

It doesn't like r*.    Expected `r` to be a Relationship but it was a Collection.  I'm using 1.9.5

[Michael Hunger]

MATCH (root:Customer)-[rels*]->(child)

WHERE root.id = {custId}
   AND NONE(r in rels : type(r) IN ["exception1", "exception2", "exception3"])
RETURN *

[Karol Brejna]

   AND NONE(r in rels : type(r) IN ["exception1", "exception2", "exception3"])

I think it should be: and none(r in rels WHERE typer(r) in  ["exception1", "exception2", "exception3"])

Where in place of colon.

Regards,

Karol

[Michael Hunger]

True that ;) thx

Sent from mobile device

--