如何从Neo4j Cypher查询结果中排除null或空数组值？

方法1：正确使用apoc.map.clean过滤空数组 #

你之前用apoc.map.clean没得到预期结果，大概率是没指定对要移除的空值类型。这个函数需要明确传入要清理的空值集合，针对空数组的情况可以这么写：

MATCH (e:Employee)
// 这里替换成你生成connections的原有逻辑
WITH e, {
  education: [(e)-[:HAS_EDUCATION]->(edu) | edu],
  has_unavailability: [(e)-[:HAS_UNAVAILABILITY]->(u) | u],
  projects: [(e)-[:WORKS_ON]->(p) | p]
} AS connections
// 第三个参数[[]]表示移除值为空数组的键
WITH e, apoc.map.clean(connections, [], [[]]) AS cleaned_connections
RETURN e.name, cleaned_connections AS connections

方法2：手动构建过滤后的Map #

如果APOC函数用着不顺，直接手动判断每个数组的长度，只保留非空的键值对：

MATCH (e:Employee)
WITH e, 
  [(e)-[:HAS_EDUCATION]->(edu) | edu] AS education,
  [(e)-[:HAS_UNAVAILABILITY]->(u) | u] AS has_unavailability,
  [(e)-[:WORKS_ON]->(p) | p] AS projects
// 逐个判断，只有数组非空才加入最终map
WITH e, 
  (CASE WHEN size(education) > 0 THEN {education: education} ELSE {} END) +
  (CASE WHEN size(has_unavailability) > 0 THEN {has_unavailability: has_unavailability} ELSE {} END) +
  (CASE WHEN size(projects) > 0 THEN {projects: projects} ELSE {} END) AS cleaned_connections
RETURN e.name, cleaned_connections AS connections

方法3：动态过滤键值对（适合多键场景） #

如果connections里的键比较多，不想逐个写CASE，用apoc.map.fromPairs动态过滤：

MATCH (e:Employee)
// 先把所有键和对应的数组做成键值对列表
WITH e, [
  ["education", [(e)-[:HAS_EDUCATION]->(edu) | edu]],
  ["has_unavailability", [(e)-[:HAS_UNAVAILABILITY]->(u) | u]],
  ["projects", [(e)-[:WORKS_ON]->(p) | p]]
] AS keyValuePairs
// 过滤掉值为空数组的键值对
WITH e, [pair IN keyValuePairs WHERE size(pair[1]) > 0] AS filteredPairs
// 把过滤后的列表转成map
WITH e, apoc.map.fromPairs(filteredPairs) AS cleaned_connections
RETURN e.name, cleaned_connections AS connections

内容的提问来源于stack exchange，提问作者Manuel Maguga Darbinian