Functions

Functions

The functions of the expression language, by category.

NameSignature
Absoluteabs(anyNumberExpression)
Addadd(...anyNumberExpression)
Ceilingceil(anyNumberExpression)
Dividedivide(anyNumberExpression, anyNumberExpression)
Floorfloor(anyNumberExpression)
Modulomod(anyNumberExpression, anyNumberExpression)
Multiplymultiply(...anyNumberExpression)
Powerpow(anyNumberExpression, anyNumberExpression)
Roundround(anyNumberExpression, anyNumberExpression)
Subtractsubtract(anyNumberExpression, anyNumberExpression)
Truncatetrunc(anyNumberExpression, anyNumberExpression)
NameSignature
Andand(...anyBooleanExpression)
Notnot(anyBooleanExpression)
Oror(...anyBooleanExpression)
NameSignature
Equaleq(anyExpression, anyExpression)
Greater thangt(anyNumberExpression, anyNumberExpression)
Greater or equalgte(anyNumberExpression, anyNumberExpression)
Less thanlt(anyNumberExpression, anyNumberExpression)
Less or equallte(anyNumberExpression, anyNumberExpression)
Not equalne(anyExpression, anyExpression)
Starts withstartsWith(anyStringExpression, anyStringExpression)
Ends withendsWith(anyStringExpression, anyStringExpression)
Containscontains(anyStringExpression, anyStringExpression)
NameSignature
Concatconcat(...anyStringExpression)
Trim startltrim(anyStringExpression)
Trim endrtrim(anyStringExpression)
Splitsplit(anyStringExpression, anyStringExpression)
LengthstrLen(anyStringExpression)
Substringsubstring(anyStringExpression, anyNumberExpression, anyNumberExpression)
LowercasetoLower(anyStringExpression)
UppercasetoUpper(anyStringExpression)
Trimtrim(anyStringExpression)
NameSignature
Add daysaddDays(dateValueExpression, anyNumberExpression)
Subtract dayssubtractDays(dateValueExpression, anyNumberExpression)
Days betweendateDiff(dateValueExpression, dateValueExpression)
Format dateformatDate(dateValueExpression, anyStringExpression)
NameSignature
Filterfilter({ input: anyArrayExpression, as: textExpression, cond: anyBooleanExpression })
Firstfirst(anyArrayExpression)
Lastlast(anyArrayExpression)
Lengthlength(anyArrayExpression)
Maxmax(anyArrayExpression)
Minmin(anyArrayExpression)
Poppop(anyArrayExpression)
Shiftshift(anyArrayExpression)
ReversereverseArray(anyArrayExpression)
Array to objectarrayToObject(anyArrayExpression)
Concat arraysconcatArrays(...anyArrayExpression)
Everyevery({ input: anyArrayExpression, as: textExpression, cond: anyBooleanExpression })
Somesome({ input: anyArrayExpression, as: textExpression, cond: anyBooleanExpression })
Findfind({ input: anyArrayExpression, as: textExpression, cond: anyBooleanExpression })
Find indexfindIndex({ input: anyArrayExpression, as: textExpression, cond: anyBooleanExpression })
Mapmap({ input: anyArrayExpression, as: textExpression, in: anyExpression })
Reducereduce({ input: anyArrayExpression, initialValue: anyExpression, in: anyExpression })
First NfirstN({ n: anyNumberExpression, input: anyArrayExpression })
Last NlastN({ n: anyNumberExpression, input: anyArrayExpression })
Max NmaxN({ n: anyNumberExpression, input: anyArrayExpression })
Min NminN({ n: anyNumberExpression, input: anyArrayExpression })
Element atarrayElemAt(anyArrayExpression, anyNumberExpression)
Index ofindexOfArray(anyArrayExpression, anyExpression)
Inin(anyExpression, anyArrayExpression)
Pushpush(anyArrayExpression, anyExpression)
Unshiftunshift(anyArrayExpression, anyExpression)
Sliceslice(anyArrayExpression, anyNumberExpression, anyNumberExpression)
SortsortArray({ input: anyArrayExpression, sortBy: anyNumberExpression })
Splicesplice({ input: anyArrayExpression, start: anyNumberExpression, deleteCount: anyNumberExpression, items: anyArrayExpression })
NameSignature
Conditioncond({ if: anyBooleanExpression, then: anyExpression, else: anyExpression })
Switchswitch({ branches: { type: "array", data: { type: "object", data: { case: anyBooleanExpression, then: anyExpression } }[] }, default: anyExpression })
NameSignature
Get valuegetValue({ input: anyObjectExpression, key: anyStringExpression })
Set valuesetValue({ input: anyObjectExpression, key: anyStringExpression, value: anyExpression })
Merge objectsmergeObjects(...anyObjectExpression)
Object to arrayobjectToArray(anyObjectExpression)