对列表中的节点计数时结果错误

我学会了如何连续多次过滤,从而得到想要的结果:

WITH ["a", "b", "c", "d"] as list
MATCH  (n:Node)--(g:Group)
WHERE n.name IN list
WITH g, COUNT(n) as intersectionSize
MATCH (n2:Node)--(g)
RETURN g, COUNT(n2) as groupSize, intersectionSize
ORDER BY intersectionSize DESC

我希望能更简洁些,但是。。。

[编辑]

你不应该使用 MATCH Node 节点,因为这会创建每个节点的大量重复引用。同样,同一对将被发现两次(按相反的顺序)。

此查询可能会执行您想要的操作:

WITH ["a", "b", "c", "d"] as list
MATCH (n:Node)--(g:Group)
WITH list, g, COLLECT(n) AS ns
WITH g, SIZE(ns) AS groupSize, SIZE([x IN ns WHERE x.name IN list]) AS intersection
WHERE intersection > 0
RETURN g, groupSize, intersection