apoc.coll.containsAll

此函数已弃用。请改用 Cypher 的 all() 函数。

详细信息

语法

apoc.coll.containsAll(coll1, coll2)

描述

返回给定的值是否全部存在于指定的集合中。

参数

名称

类型

描述

coll1

LIST<ANY>

要在其中搜索给定值的列表。

coll2

LIST<ANY>

要检查是否存在于给定列表中的值列表。

返回

布尔值 (BOOLEAN)

使用示例

以下示例演示了如何分别使用 APOC 和 Cypher 检查一个集合是否包含另一个集合中的所有值

apoc.coll.containsAll
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