[Neo4j] Re: how to find multiple simular relstionships

2018-01-04 Thread koen
Hi Kamal, thanks. This also gives a nice result but i was also looking for a more generic approach answering for example the question: what are all objects that a specific user has access to.. or which users have access to what object.. I think the combination of a COLLECTc and ALL clause did th

[Neo4j] Re: how to find multiple simular relstionships

2018-01-04 Thread Kamal Murthy
Hi Koen, Try these scripts: MATCH (o:Object)-[]->(c)-[]-(d)-[]-(e)-[]-(f) WHERE o.name = "a11" and f.name <> "a21" and f.name <> "l11" and f.name <> "l12" and f.name <> "u2" RETURN o, c, d, e, f;

Re: [Neo4j] Re: how to find multiple simular relstionships

2018-01-04 Thread Koen Kleingeld
Hi Craig, thanks, yes i know i could have combined my query into one but this was just to split things out. Its only purpose was to create the initial subset of the bigger graph that would be input for the actual query.. I tried your query but it does not give any results back but with some help

[Neo4j] Re: how to find multiple simular relstionships

2018-01-04 Thread Craig Taverner
Hi Koen, As I see it one problem with your query is that it is performing multiple matches that will build on each other, and that is not what you are asking for. The first match will return two rows, one for each of the two paths that match that pattern. Then for each of these rows Cypher will