Re: [Neo4j] neo4j 4.1.3 -> Where condition with count not working as expected

2020-12-07 Thread 'Shanthi Viswanathan' via Neo4j
Thanks much Michael - your explanation makes sense. I am using dynamic relationship because this is part of a cypher where my role (the "Test" I have in my example) is dynamic. On Mon, Dec 7, 2020 at 7:02 AM 'Michael Hunger' via Neo4j < neo4j@googlegroups.com> wrote: > Best to send questions

Re: [Neo4j] neo4j 4.1.3 -> Where condition with count not working as expected

2020-12-07 Thread 'Michael Hunger' via Neo4j
Best to send questions like this to community.neo4j.com In general if you aggregate, you must not add the thing you want to count / aggregate on as an aggregation key, you can use collect on those. MATCH (echk:REC {id: 'abcdef'}) OPTIONAL MATCH (p:Person) WHERE p.name CONTAINS 'Shirley' WITH

[Neo4j] neo4j 4.1.3 -> Where condition with count not working as expected

2020-12-07 Thread 'Shanthi Viswanathan' via Neo4j
I am using neo4j 4.1.3. I have 2 labels : Person and Rec. I need to create a relationship between these 2 only when there exists exactly one person with that last name. When I run the below, relationships are created for all persons with that last name. My code is below: MATCH (echk:REC {id: