|| apoc.coll.containsAll - APOC 核心文档 - Neo4j 文档

apoc.coll.containsAll

详情
语法	`apoc.coll.containsAll(coll1, coll2)`
描述	返回给定集合中是否包含所有给定值（使用 HashSet）。
参数	名称	类型	描述
	`coll1`	`LIST<ANY>`	要在其中搜索给定值的列表。
	`coll2`	`LIST<ANY>`	要检查其存在性的给定列表中的值列表。
返回	`BOOLEAN`

使用示例

以下示例检查一个集合是否包含另一个集合中的所有值，同时使用 APOC 和 Cypher

WITH [1,2,3,4,5] AS mainList, [3,7] AS sublist
RETURN apoc.coll.containsAll(mainList, sublist) AS output

Cypher 的 all()

WITH [1,2,3,4,5] AS mainList, [3,7] AS sublist
RETURN all(x IN sublist WHERE x IN mainList) AS output

结果
输出
false

apoc.coll.containsAll

WITH [1,2,3,4,5] AS mainList, [1,3] AS sublist
RETURN apoc.coll.containsAll(mainList, sublist) AS output

Cypher 的 all()

WITH [1,2,3,4,5] AS mainList, [1,3] AS sublist
RETURN all(x IN sublist WHERE x IN mainList) AS output

结果
输出
true

apoc.coll.containsAll

WITH [1,2,3,4,5] AS mainList, [4,1] AS sublist
RETURN apoc.coll.containsAll(mainList, sublist) AS output

Cypher 的 all()

WITH [1,2,3,4,5] AS mainList, [4,1] AS sublist
RETURN all(x IN sublist WHERE x IN mainList) AS output

结果
输出
true