Skip to main content

Function and operator catalog

The catalog and the operator table are closed and enumerated — new capability is added as a named, typed entry, and this page is regenerated from that entry, never hand-edited. Every example shown below is executed as an assertion by the engine's own test suite (examples.test.ts), so a result shown here is a result the engine actually produces for that input.

Catalog version: 2.0.0 Catalog content hash: ad6ea5b0ea1d49acd7b41a5fa9642bf99bab0e78db3768b2a2fc0dcf17c85597 Hash scope: every .ts file under packages/engine/src/analysis, recursively, excluding *.test.ts files and catalog-hash.ts itself — the whole analysis tree, not only the catalog directory, because an operator implementation or a shared helper outside the catalog directory can also change what an expression evaluates to

The catalog is split across seven pages, one per group below — open one directly, or use the name index further down to jump straight to the entry you need.

GroupEntriesHolds
Aggregation5SUM, AVG, MIN, MAX, COUNT
Collections10GROUPBY, FIND_BY, GET, ARGS, SLICE, LENGTH, INCLUDES, JOIN, COMPACT, FLATTEN
Number3ABS, ROUND, PARSENUMBER
Logic & Fallback2IF, COALESCE
String12UPPER, LOWER, TRIM, SUBSTRING, SPLIT, REPLACE, CONCAT, INDEXOF, LASTINDEXOF, PADSTART, PADEND, REPEAT
Date13NOW, TODAY, DATE, YEAR, MONTH, DAY, ADD_DAYS, ADD_MONTHS, DIFF_DAYS, START_OF_DAY, END_OF_DAY, PARSEDATE, FORMATDATE
Operators & Precedence25Every condition operator ENG-08 enumerates, plus the parser's operator precedence table

Find a name​

Every function and operator name, alphabetically, linking to the page that documents it.

NamePage
ABSNumber
ADD_DAYSDate
ADD_MONTHSDate
ARGSCollections
AVGAggregation
COALESCELogic & Fallback
COMPACTCollections
CONCATString
COUNTAggregation
DATEDate
DAYDate
DIFF_DAYSDate
END_OF_DAYDate
FIND_BYCollections
FLATTENCollections
FORMATDATEDate
GETCollections
GROUPBYCollections
IFLogic & Fallback
INCLUDESCollections
INDEXOFString
JOINCollections
LASTINDEXOFString
LENGTHCollections
LOWERString
MAXAggregation
MINAggregation
MONTHDate
NOWDate
PADENDString
PADSTARTString
PARSEDATEDate
PARSENUMBERNumber
REPEATString
REPLACEString
ROUNDNumber
SLICECollections
SPLITString
START_OF_DAYDate
SUBSTRINGString
SUMAggregation
TODAYDate
TRIMString
UPPERString
YEARDate
addOperators & Precedence
andOperators & Precedence
approxEqualOperators & Precedence
containsOperators & Precedence
divOperators & Precedence
doesNotContainOperators & Precedence
endsWithOperators & Precedence
equalOperators & Precedence
existsOperators & Precedence
greaterThanOperators & Precedence
greaterThanInclusiveOperators & Precedence
inOperators & Precedence
isNullOperators & Precedence
lessThanOperators & Precedence
lessThanInclusiveOperators & Precedence
matchesOperators & Precedence
mulOperators & Precedence
notOperators & Precedence
notEqualOperators & Precedence
notExistsOperators & Precedence
notInOperators & Precedence
orOperators & Precedence
regexMatchOperators & Precedence
startsWithOperators & Precedence
subOperators & Precedence