Was this helpful?
Core DataFlow Functions
In addition to the default operators, the expression language supports many other scalar valued functions included in the DataFlow core library.
Constant Value Functions
The library provides several functions that can provide references to known values. You can use them to combine constant values with other functions. Available functions are listed in Available Functions.
Conversion Functions
The library provides a selection of functions to convert between various datatypes. These functions are for conversions that would not normally be permitted by the token type system, as they are either possibly “lossy” (such as type narrowing) or ambiguous (such as string formatting). Available functions are listed in Available Functions.
Date and Time Functions
The library provides implementations of several common date/time functions. Unless otherwise stated, functions can be applied to any of the date/time types including Date, Time, or Timestamp. Some of the functions use special enumerations that are available within the DateTime class.
Part is a string constant and must be one of the following:
SECOND
SECOND_OF_MINUTE
MINUTE
MINUTE_OF_HOUR
HOUR
HOUR_OF_DAY
DAY_OF_WEEK
DAY
DAY_OF_MONTH
DAY_OF_YEAR
WEEK
WEEK_OF_YEAR
MONTH
YEAR
Granularity is a string constant and must be one of the following:
MILLISECOND
SECOND
MINUTE
HOUR
DAY
WEEK
MONTH
YEAR
CENTURY
TimeZone is a string constant. It can be given as an offset from GMT ("GMT-5", "GMT+8:30", etc.) or as a valid time zone name from the tz database ("America/Chicago", "Asia/Tokyo", "Europe/London", etc.). If no time zone is specified, the default time zone of the local machine is used. If an invalid time zone is specified, the expression will be invalid.
For the list of available functions, see Available Functions.
Formatting Functions
The library provides several implementations of common formatting functions. The format specification is defined by java.util.Formatter. Reference the java.util.Formatter documentation for the capabilities and limitations of the available formatting functions. The format specification is not validated before being used. Therefore, errors in the format specification are not discovered until execution.
Available functions are listed in Available Functions.
Math Functions
The library provides implementations of common math functions found in the java.lang.Math library.
All trigonometric functions use radians by default. Use the toDegrees and toRadians functions to convert between radians and degrees.
Available functions are listed in Available Functions.
Statistics Functions
The library provides implementations of several common statistical functions that can be used to calculate aggregates within a field.
Available functions are listed in Available Functions.
String Functions
The library provides implementations of the common string manipulation functions.
Available functions are listed in Available Functions.
List Functions
The library provides implementations of common List functions.
Available functions are listed in Available Functions.
Map Functions
The library provides implementations of common Map functions.
Available functions are listed in Available Functions.
Last modified date: 01/06/2023