Background
I have a neo4j database set up with the following nodes;
(:game)-[:teamscore]-(:team)
The 'game' node would contain an id
, a date
and a name
The 'team' node link would contain an id
, a teamname
and an score
.
Desired Outcome
I am looking to match nodes where teamname
= "TeamA" but only where there isn't a linked node that exists with a different team for that 'game'.
(in plain English)
I want to return all nodes relating to a game where only 'TeamA' has scored (and not conceded).
What I have so far
MATCH(g:game)-[:teamscore]-(t:team)
WHERE g.team = "TeamA"
RETURN g, t
I thought about adding some kind of NOT (g)-[:teamscore]-(:team)
to the WHERE clause but I'm not sure how I could do this in a way which doesn't eliminate the node which I do want to match.
Thanks in advance for any help on this!