neo4j - 如何获取neo4j路径中的最后一个节点？

Question

在此密码查询中，将返回与STATUS =“on”属性相互关联的节点之间的最长路径/路径，但我也想获得路径/路径的最后一个节点。

询问:

START n=node(*)
MATCH p=n-[rels:INCLUDE*]->m 
WHERE ALL (rel IN rels 
  WHERE rel.status='on') 
WITH COLLECT(p) AS paths, MAX(length(p)) AS maxLength 
RETURN FILTER(path IN paths 
  WHERE length(path)= maxLength) AS longestPaths

我应该如何将其添加到查询中？
谢谢。

Answer 1

这将给出两个数组。第一个数组是每个路径中的最后一个项目，第二个数组是每个路径:

START n=node(*)
MATCH p=n-[rels:INCLUDE*]->m 
WHERE ALL (rel IN rels 
  WHERE rel.status='on') 
WITH COLLECT(p) AS paths, MAX(length(p)) AS maxLength 
WITH FILTER(path IN paths WHERE length(path)= maxLength) AS longestPaths
RETURN EXTRACT(path IN longestPaths | LAST(path)) as last, longestPaths