Array functions

SIZE(A)

Size of array A

SIZE( items )

FILTER(A, C)

Filters the array A with filter condition C

FILTER( items, type == "service" )

SORT_ASC(A, F)

Sorts the array A into ascending order based on F field

SORT_ASC( items, price )

SORT_DESC(A, F)

Sorts the array A into descending order based on F field

SORT_DESC( items, date )

GET(A, N)

Returns the N-th item of array A

GET( items, 2 )

FIRST(A)

Returns first item of array A

FIRST( items )

LAST(A)

Returns last item of array A

LAST( items )

MAP(A, E)

Transforms A array into list of values calculated by expression E

MAP( items, name )

JOIN(A, S)

Joins array A with separator S into single text

JOIN( countries, ", " )