Angela Thompson interacts with Braveheart movie. Recommend her a Movie based on other users who ...

[miklov]

Angela Thompson interacts with Braveheart movie. Recommend her a Movie based on other users who have also seen Braveheart.

Hello, 

I've been trying to code the above from the MovieLens database but i dont get it right. This is what i did so far, can someone help please?

MATCH (u1:User{name:"Angela Thompson"})

MATCH(m1:Movie {title: "Braveheart"})

MATCH (u1:User{name:"Angela Thompson"})-[:RATED]->(m1:Movie)-[:IN_GENRE]->(g:Genre)<-[:IN_GENRE]-(m2:Movie)<-[:RATED]-(m1:Movie {title: "Braveheart"})

WITH  COUNT(*) AS usersWhoAlsoWatched

RETURN *;

[glilienfield]

What is your database model? 

[miklov]

Hello glilienfield,

I am using the MovieLens database

[Cobra]

Execute this command in Neo4j Browser:

CALL db.schema.visualization();

 and upload the result here.

[miklov]

This is what i got

[Cobra]

This query should do what you want:

MATCH (u:User {name: "Angela Thompson"})-[:RATED]->(:Movie {title: "Braveheart"})<-[:RATED]-(:User)-[:RATED]->(m:Movie)
RETURN m.title AS movie, count(*) AS count

[miklov]

It only gives me a table, how do i get the graph?

[Cobra]

What graph do you want? If you want to see Movie nodes, just do:

RETURN m, count(*) AS count

[miklov]

i want to see this graph