6.5. Find people based on similar favorites

Figure 6.5. Graph

To find out the possible new friends based on them liking similar things as the asking person, use a query like this:

Parameters 

{ }

Query 

MATCH (me { name: 'Joe' })-[:favorite]->(stuff)<-[:favorite]-(person)
WHERE NOT (me)-[:friend]-(person)
RETURN person.name, count(stuff)
ORDER BY count(stuff) DESC

The list of possible friends ranked by them liking similar stuff that are not yet friends is returned.

Result

person.namecount(stuff)
2 rows

"Derrick"

2

"Jill"

1