I'm working on a project that stores our customers relationships in Neo4j. Our model looks like this: (Client) - [PARENT_OF] - (Client). Each Client can have up to 3 different labels assigned.
I made a query that at first glance should work but it's not returning the nodes from the path as a List.
Here is my query "MATCH p = (n:Client)-[r:PARENT_OF*]->(t:Client) WHERE n.code="MYCODE" RETURN nodes(p) as nodes , labels(n) as labels"
In the docs I read that the nodes() function takes a path as parameter and then outputs the nodes from the path as a list. When I execute the query from the browser it returns each node from nodes as an array containing the parent node and its child.
It's not still clear what you are trying to do and what is the expected output. You get 3 rows in the output because there are 3 paths. nodes returns all nodes in a path incuding the first and the last nodes. If you don't need the first one, you can use the tail function. For example, tail([1,2,3]) returns [2,3]. So just pass the nodes(p) to the tail function and you will get all nodes but the first one.
Sorry if I am not answering your question. I did my best given the level of details I found in the question.
What you're looking for is a way to flatten your list of lists, and then unwind (or pivot them).
MATCH p = (n:Client)-[r:PARENT_OF*]->(t:Client)
// nodes(p) is an array of arrays. the reduce is similar to a flat function.
WITH reduce(output = , n IN nodes(p) | output + n ) as nodeCollection
// here we take the single row of the flattened array and pivot it to rows.
UNWIND nodeCollection as client
// once we have each client in it's own row, then we call labels
// Also don't forget the distinct!
// Remember the arrays simply flatten out each path, 2 of your nodes show up in multiple paths.
RETURN distinct client, labels(client)
I hope that was informative while also helping answer the question.
If you have any other follow on questions, let me know
Oh my god Mike, thanks for your reply it works like a charm!
I have yet to understand how flat functions works and the syntax for the reduce function too but for the sake of the query I think I get it.