DocumentationJourney OptimizerJourney Optimizer Guide

[Legacy]{class="badge informative"}

Supported functions in the personalization editor personalization-editor-supported-functions

Last update: Tue Mar 03 2026 00:00:00 GMT+0000 (Coordinated Universal Time)
  • Applies to:
  • Journey Orchestration

CREATED FOR:

  • Intermediate
  • User

In Decision management, you use the personalization editor when you add representations and personalize offer content (images, text, links in your offers).

The Offer Decisioning backend supports only a subset of the functions available in the personalization editor when personalizing that content. This page lists every function you can safely use in the editor for offer content. Expand each section to see the supported operators, helpers, and functions.

NOTE
This function list applies only to personalizing offer content (representations). Decision rules and ranking formulas use different editors and are not limited to this subset.

Supported functions list supported-functions-list

Operators
  • Arithmetic: + - * / %
  • Logical: and or !
  • Comparison: = != > >= < <=
Helpers
  • Each
  • With
  • If
  • Unless
  • Let
  • Default fallback value
  • fragment
  • datasetLookup
  • externalDataLookup (Alpha)
  • Inline
  • Url
  • Execution Metadata
  • valueAtPath
String functions
table 0-row-2 1-row-2 2-row-2 3-row-2 4-row-2 5-row-2 6-row-2 7-row-2 8-row-2 9-row-2 10-row-2 11-row-2 12-row-2 13-row-2 14-row-2 15-row-2 16-row-2 17-row-2 18-row-2 19-row-2 20-row-2 21-row-2 22-row-2 23-row-2 24-row-2 25-row-2 26-row-2 27-row-2 28-row-2 29-row-2 30-row-2 31-row-2 32-row-2 33-row-2 34-row-2 35-row-2 36-row-2 37-row-2 38-row-2 39-row-2 40-row-2 41-row-2 42-row-2 43-row-2 44-row-2 45-row-2
Display name Internal name
Lower case lowerCase
Upper case upperCase
Camel case camelCase
Title case titleCase
Trim trim
Left Trim leftTrim
Right Trim rightTrim
Is Empty isEmpty
Equals Ignore Case equalsIgnoreCase
Not Equal With Ignore Case notEqualWithIgnoreCase
Replace replace
Replace All replaceAll
Concat concat
Split split
Encode64 encode64
Length length
MD5 md5
SHA256 sha256
Like like
Starts with startsWith
Does not start with doesNotStartWith
Ends with endsWith
Does not end with doesNotEndWith
Contains contains
Does not contain doesNotContain
Equals equals
Not equal to notEqualTo
Matches matches
Regular expression group regexGroup
String to number stringToNumber
String to date stringToDate
To Date Time toDateTime
To Date Time Only toDateTimeOnly
Extract email domain extractEmailDomain
Extract email username extractEmailUsername
Is Not Empty isNotEmpty
Index Of indexOf
Last Index Of lastIndexOf
Sub string substr
To Bool toBool
String to integer string_to_integer
Mask mask
Get format currency formatCurrency
Get unicode value of character charCodeAt
Get Qr Code for any text qrCode
Array, list and set functions
table 0-row-2 1-row-2 2-row-2 3-row-2 4-row-2 5-row-2 6-row-2 7-row-2 8-row-2 9-row-2 10-row-2 11-row-2 12-row-2 13-row-2 14-row-2 15-row-2
Display name Internal name
Distinct distinct
In in
Not in notIn
Intersects intersects
Subset of subsetOf
Superset of supersetOf
Includes includes
Sort and get first N in array topN
Sort and get last N in array bottomN
First item head
Count count
Sum sum
Average average
Minimum min
Maximum max
Map functions
table 0-row-2 1-row-2 2-row-2 3-row-2
Display name Internal name
Get get
Keys keys
Values values
Object functions
table 0-row-2 1-row-2 2-row-2
Display name Internal name
Is null isNull
Is not null isNotNull
Math functions
table 0-row-2 1-row-2 2-row-2 3-row-2 4-row-2 5-row-2 6-row-2 7-row-2 8-row-2 9-row-2 10-row-2 11-row-2
Display name Internal name
To Percentage toPercentage
Round Up roundUp
Round down roundDown
To Precision toPrecision
Absolute absolute
Random random
To Hexadecimal toHexString
Get number to locale formatNumber
To String toString
To Int toInt
To Long toLong
Date time functions
table 0-row-2 1-row-2 2-row-2 3-row-2 4-row-2 5-row-2 6-row-2 7-row-2 8-row-2 9-row-2 10-row-2 11-row-2 12-row-2 13-row-2 14-row-2 15-row-2 16-row-2 17-row-2 18-row-2 19-row-2 20-row-2 21-row-2 22-row-2 23-row-2 24-row-2 25-row-2 26-row-2 27-row-2 28-row-2 29-row-2 30-row-2 31-row-2 32-row-2 33-row-2 34-row-2 35-row-2 36-row-2 37-row-2
Display name Internal name
Now now
Get CurrentZonedDateTime getCurrentZonedDateTime
To Date toDate
To Time toTime
To Date Time toDateTime
To Date Time Only toDateTimeOnly
To Date Only toDateOnly
To Time Only toTimeOnly
To Time Zone toTimeZone
Format date formatDate
Format date time formatDateTime
Format time formatTime
Parse date parseDate
Parse date time parseDateTime
Parse time parseTime
Add Days addDays
Add Months addMonths
Add Years addYears
Add Hours addHours
Add Minutes addMinutes
Add Seconds addSeconds
Subtract Days subtractDays
Subtract Months subtractMonths
Subtract Years subtractYears
Subtract Hours subtractHours
Subtract Minutes subtractMinutes
Subtract Seconds subtractSeconds
Difference in Days diffDays
Difference in Months diffMonths
Difference in Years diffYears
Difference in Hours diffHours
Difference in Minutes diffMinutes
Difference in Seconds diffSeconds
Start of day startOfDay
End of day endOfDay
Is Before isBefore
Is After isAfter
URL functions
table 0-row-2 1-row-2 2-row-2 3-row-2 4-row-2 5-row-2
Display name Internal name
Encode URL encodeUrl
Decode URL decodeUrl
Get URL query param getUrlQueryParam
Get URL protocol getUrlProtocol
Get URL host getUrlHost
NOTE
If you use a function that is not in the list above when personalizing offer content, the expression may fail at runtime or produce unexpected results. For the full set of functions available in Journey Optimizer personalization, see Helper functions list. Only the subset documented on this page is supported for personalizing content in Offer Decisioning.
recommendation-more-help
b22c9c5d-9208-48f4-b874-1cefb8df4d76