apoc.coll.containsAllSorted

Details

Syntax

apoc.coll.containsAllSorted(coll1, coll2)

Description

Returns whether or not all of the given values in the second LIST<ANY> exist in an already sorted collection (using a binary search).

Arguments

Name

Type

Description

coll1

LIST<ANY>

The sorted list to search for the given values.

coll2

LIST<ANY>

The list of values to check for existence of in the given list.

Returns

BOOLEAN

Usage examples

The following checks if a sorted collection contains all the values from another collection:

RETURN apoc.coll.containsAllSorted([1,4,5], [1,4]) AS output;
Results
Output

TRUE

This function will not work on unsorted collections, as shown in the example below:

RETURN apoc.coll.containsAllSorted([1,5,4], [1,4]) AS output;
Results
Output

FALSE

If we want to find values in an unsorted collection, see apoc.coll.containsAll.