Cypher query to return nested data hierarchically

Question

(:Dot)-[:CONTAINS]->(:Dot)

Not every dot has a container and also there are no loops. Atm a dot can only be contained by one other dot. So we are basically talking about trees

Now I would like to use Neo4j to retrieve the data and return it hierarchally (by containers):

[
    {"id": 1, "containees": [
        {"id": 3},
        {"id": 4, "containees": [
            {"id": 6},
        ]},
    ]},
    {"id": 2, "containees": [
        {"id": 5}
    ]}
]

The query shouldn't use a fixed depth.

Atm I only have this, and I'm really not sure what my options are concerning iterating a path.

MATCH (d:Dot)
OPTIONAL MATCH p = d-[:CONTAINS*]->(d2:Dot)
RETURN d.id

Brian Underwood · Accepted Answer · 2015-04-06 12:28:53Z

2

I'm pretty sure this isn't possible currently with Cypher (somebody please correct me if I'm wrong). Cypher is good at taking subgraph matches and turning them into tables, but it doesn't do recursive-type querying.

For this sort of thing I think you'd need to work through the Java APIs directly. Either by interfacing with Java with your language of choice, or by creating an unmanaged extension to have Neo4j return the data for you in JSON (or whatever format you'd like)

answered Apr 6, 2015 at 12:28

Brian Underwood

10.9k1 gold badge25 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Cypher query to return nested data hierarchically

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related