Collection macros

Discover the available macros to work with collections in CQL.

Croct's mascot winking
Looking for something specific?

Use the search bar at the top of the page or press / to quickly search through the documentation.

Use the summary below to quickly jump to a specific topic:

PageDescription
CountLearn how to count items in a collection.
MinimumLearn how to find the smallest number in a collection.
MaximumLearn how to find the largest number in a collection.
SumLearn how to calculate the sum of a collection of numbers.
AverageLearn how to calculate the average of a collection of numbers.
First elementLearn how to get the first element of a collection.
Last elementLearn how to get the last element of a collection.
KeysLearn how to get the keys of a collection.
SublistLearn how to select a range of elements from a collection.