CODEWITHSUNDEEP
cypher
dwjohnston
dwjohnston

Reputation: 11890

How do I do a WHERE clause on a COUNT in Cypher?

This is what I'm trying:

match 
(e:Person) - [r] - (f:Person) 
where (count(r) > 5 AND count (r) <10) 
return id(e), e.name;

I get

QueryExecutionKernelException: Invalid use of aggregating function count(...) in this context

Basically I'm wanting to find a Person who is related to between 5 and 10 other Persons.

Upvotes: 13

Views: 11965

Answers (1)

cechode
cechode

Reputation: 1022

to find out people who are connected with each other by more than relationship ex:

  • a likes b
  • a knows b
  • a lives_with b

use

match (a:Person)-[r]-(b:person)
with a,b,count(r) as cnt
where cnt > 5 and cnt < 10
return *

if however you want to find people who are connected as a chain ( friends of friends )

  • a knows b
  • b knows c
  • c likes d
  • d knows e

and you want to find a to d then you can use something like

MATCH (n:Person)-[r*1..3]->(m:Person)
RETURN *

relevant tutorial here

Upvotes: 17

Related Questions