Neo4j Cypher：基于另一个查询筛选查询结果

Question

我正在尝试查找一个查询唯一的名称列表，并排除两个查询结果之间的共同名称。例如，我想要学生A、B和C所选课程的名称，并从该列表中排除学生D和E所选的课程。在这个问题的答案的帮助下（Neo4j Cypher:从结果中排除某些节点），我尝试了这个密码代码，它是有效的，但我得到的结果是节点。我希望它是一个名称列表，而不是节点。

Match (m:class)-[r]-(n:student) where n.name in ['aa','bb','cc']    
WITH COLLECT(m) AS EXCLUDED
MATCH  (m1:class)-[r1]-(n1:student) where n1.name in ['dd','ee'] 
WITH EXCLUDED, COLLECT(m1) AS included
RETURN FILTER(m1 IN included WHERE NOT m1 IN EXCLUDED)

非常感谢。

Answer 1

您可以有另一个AND和UNWIND。

Match (m:class)-[r]-(n:student) where n.name in ['aa','bb','cc']    
WITH COLLECT(m) AS EXCLUDED
MATCH  (m1:class)-[r1]-(n1:student) where n1.name in ['dd','ee'] 
WITH EXCLUDED, COLLECT(m1) AS included
WITH FILTER(m1 IN included WHERE NOT m1 IN EXCLUDED) as _results
UNWIND _results as results
RETURN results.name

注意：FILTER（）在neo4j 3.5中被弃用，在4.0中被删除，有利于列表理解