Get only the nodes multiple users all have in common

Neo4j Graph Platform Cypher
1

Good evening,
I have this graph:

2019-10-31_18-46
2019-10-31_18-46.png1398×772 48.1 KB

I would like to get only the users and nodes all users have in common.
But don't know how to get the data.

How can I get - from all - users the nodes/directory "this one" all the users have in common?

Yours kindly
Omer
The Netherlands

2

Hi Omer,

If I've understood your question correctly, you want to get all the common user nodes that link between both directories tagged "this one"?

If so, something like this should do the job (based on your model above):

//specify the path pattern between the two nodes:
MATCH (:directory {name:"this one"})<--(:group)<--(u:user)-->(:group)-->(:directory {name:"this one"})
//return the user node names  that are across this pattern path
RETURN u.name;

Bear in mind that this is assuming the strict alternation between user--group--directory.

3

Thank you for the reply.
I know the users.
But I don 't know the directory "this one".

Is there a analyses possible to get only:
These users all share these nodes.

Mvrgr Omer