append()

Adds an element to the end of a list and returns the new list.

with ["a", 1, 2] as myList
return append(myList, "b")

Result:

difference()

Returns the difference between two lists, producing a new list of elements found in the first input list but not in the second. Duplicates are included.

with [1,2,2,3] as l1, [3,4,5] as l2
return difference(l1, l2)

Result:

head()

Returns the first element in a list.

with ["a", 1, 2] as myList
return head(myList)

Result:

intersection()

Returns the intersection of two lists, producing a new list of elements common to both. Duplicates are included.

with [1,2,3,3] as l1, [3,3,4,5] as l2
return intersection(l1, l2)

Result:

listContains()

Checks whether a specified element exists in a list, returning 1 for true and 0 for false.

with ["a", 1, 2] as myList
return listContains(myList, "b")

Result:

listUnion()

Returns the union of two lists, producing a new list of elements from either input list. Duplicates are removed.

with [1,2,2,3] as l1, [3,4,5] as l2
return listUnion(l1, l2)

Result:

reduce()

Performs a calculation iteratively using each element in a list. With a specified intital value, the defined calculation takes the first element in the list as input.

with [1,3,5] as myList
return reduce(_sum = 0, item in myList | _sum + item) AS listSum

Result:

size()

Returns the number of elements in a list.

with [1, 2, null, 3] as myList
return size(myList)

Result: