Match with OR condition

Question

been playing around with cypher for a while now and having a bit of difficulty understanding something.

assuming i have person nodes some of which might have a belongs_to relationship what would be the best way to find a node that either

• does not have a blongs_to relationship but does have an email address of "[email protected]"
• OR
• does have a belongs_to relationship with a Id Property of "100" ( the property is of the relationship)

i have managed to create some queries that return the expected data, but i don't know if those are ones that are "correct" in the long run of my cypher understanding

any help would be appreciated. ( specifically with regards to And | Or , order and efficiency )

Answer 1

Something like this?

You can use path patterns as predicates, see: http://neo4j.com/docs/2.1.5/query-where.html#query-where-patterns

MATCH (n:Person {email:"[email protected]"})
WHERE NOT (n)-[:BELONGS_TO]->() OR (n)-[:BELONGS_TO {id:100})->()
RETURN n