Cypher查询匹配所有路径

Question

我有一个像“项目”，“员工”和“技术”节点的图形。项目与技术之间以及员工与技术之间存在关系。

我想找到知道项目使用的所有技术的员工。我cyper查询看起来是这样的：

start project=node:project(name = "Project1") 
match technology <-[:USED]- project , employee -[:KNOWS]-> technology 
return employee 

当运行此查询我得到了解工程使用的一种技术，并且希望那些知道该项目使用的所有技术员工的所有员工。这是可能的密码？

Answer 1

你可以尝试这样的：

start project=node:project(name = "Project1") 
match employee -[:KNOWS]-> technology <-[:USED]- project 
with count(technology) as knownTech, employee, project 
where length(()<-[:USED]-project)=knownTech 
return employee 

见Finding nodes that have all common intermediaries

Answer 2

我可能会利用这一点避免计算每名员工由项目使用的技术数量：

start project=node:project(name = "Project1") 
match technology <-[:USED]- project 
with count(technology) as projectTech, project 
match employee -[:KNOWS]-> technology <-[:USED]- project 
with count(technology) as knownTech, projectTech, employee 
where projectTech=knownTech 
return employee