apoc.coll.subtract

Function

apoc.coll.subtract(list1 [Any], list2 [Any]) - returns the first list as a set with all the elements of the second list removed.

Signature

apoc.coll.subtract(first :: LIST? OF ANY?, second :: LIST? OF ANY?) :: (LIST? OF ANY?)

Input parameters

Name Type Default

first

LIST? OF ANY?

null

second

LIST? OF ANY?

null

Usage examples

The following returns unique set of first list with all elements of second list removed:

RETURN apoc.coll.subtract([1,2,3,4,5,6,6], [3,4,5]) AS output;
Table 1. Results
Output

[1, 2, 6]