匹配具有相同属性的节点之间的关系

Question

我有以下图表：

CREATE (a:Node)
CREATE (b:Node)
CREATE (c:Node)
CREATE (d:Node)

CREATE (a)-[:rel {referenceId: 1234, amount: 2}]->(b)
CREATE (b)-[:rel {referenceId: 1234, amount: 1}]->(c)
CREATE (b)-[:rel {referenceId: 1234, amount: 0.5}]->(d)

CREATE (a)-[:rel {referenceId: 4567, amount: 4}]->(b)
CREATE (b)-[:rel {referenceId: 4567, amount: 1}]->(c)
CREATE (b)-[:rel {referenceId: 4567, amount: 3}]->(d)

我正在寻找一种方法来计算从a发送到b和从b发送到c/d的金额之间的差异，这取决于referenceId，但不使用特定的referenceId。

所以我在寻找像下面这样的半代码：

MATCH (a)-[in:rel]->(b)-[out:rel]->(c) WHERE in.referenceId == out.referenceId RETURN SUM(in.amount)-SUM(out.amount)

有人知道我该怎么做吗？

Answer 1

也许你需要按照参考ID来做？

  MATCH (a)-[in:rel]->(b)-[out:rel]->(c)
     WHERE in.referenceId = out.referenceId
  RETURN in.referenceId as referenceId, 
         SUM(in.amount)-SUM(out.amount) as diff

结果：

referenceId diff
4567        4
1234        2.5

你也可以这样做，所以你寻找非零差异：

MATCH (a)-[in:rel]->(b)-[out:rel]->(c)
  WHERE in.referenceId = out.referenceId
WITH in.referenceId as referenceId,
       SUM(in.amount)-SUM(out.amount) as diff
WHERE diff <> 0
RETURN referenceId, diff