Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
1.3k views
in Technique[技术] by (71.8m points)

neo4j cypher - Match node where another specific node of the same type doesn't exist

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!


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Reply

0 votes
by (71.8m points)

You can a match team by name and then make sure only one team is linked to that game by specifying the number of teamscore relationships to that game is 1.

MATCH(g:game)-[:teamscore]-(t:team) 
WHERE t.teamname = "TeamA" AND size((g)-[:teamscore]-(:team))=1 
RETURN g, t

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
OGeek|极客中国-欢迎来到极客的世界,一个免费开放的程序员编程交流平台!开放,进步,分享!让技术改变生活,让极客改变未来! Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

1.4m articles

1.4m replys

5 comments

57.0k users

...