Expressions

Expressions can for example be used to change a member of an object based on logic. Variables in the microflow can be called in an expression by inserting the name of the variable and adding a dollar sign. E.g. $customer refers to the variable customer. Expressions can be used recursively, for example, 1 + 2 + 3. Attributes and associations of object variables are accessed using a slash, for example, $customer/Name, $customer/CRM.Customer_Order.

To illustrate this imagine an object with variable name package with two attributes: weight (Float) and shippingCosts(Decimal). Rule: if the weight of a package is less than one kilogram there are no shipping costs. Otherwise the shipping costs are €5.00. The expression for changing attribute shippingCosts is: if $package/weight < 1.00 then 0.00 else 5.00.

An overview of the possibilities with expressions can be found below.

Unary Expressions:

• Unary minus ( - )

Arithmetic Expressions:

• Multiplication ( * )
• Division ( div or : )
• Modulo ( mod )
• Addition ( + )
• Subtraction ( - )

Relational Expressions:

• Less than ( < )
• Greater than ( > )
• Less than or equal to ( <= )
• Greater than or equal to ( >= )
• Is equal to ( = )
• Is not equal to ( != )

Special checks

• Checking for an empty object
• Checking for an empty object member
• isNew - Checking whether an object is new

Boolean expressions

• and
• or
• not

If expressions

Mathematical function calls

• max - Maximum of a list of numbers
• min - Minimum of a list of numbers
• round - Rounding a floating-point number, optionally to a specified precision
• random - Random number generation
• floor - Rounding a floating-point number down
• ceil - Rounding a floating-point number up
• pow - Exponentiation
• abs - Absolute value
• floatsEqual / currenciesEqual - Equality of floats/currencies for a certain precision (deprecated)

String function calls

• toUpperCase - Convert string to uppercase
• toLowerCase - Convert string to lowercase
• length - String length
• substring - Get part of a string
• find - Get substring position
• findLast - Get last substring position
• contains - Contains substring
• startsWith - Determine whether a string starts with the specified substring
• endsWith - Determine whether a string ends with the specified substring
• trim - Remove leading and trailing whitespace
• isMatch - Match regular expression
• replaceAll - Replace occurrences of substring
• replaceFirst - Replace first occurrence of substring
• String concatenation ( + ) - Concatenate strings
• urlEncode - Convert a string to be used in a URL
• urlDecode - Convert a string back from a URL

Date creation

• dateTime - Creating a date value using the server’s calendar
• dateTimeUTC - Creating a date value using the UTC calendar

Between date function calls

• millisecondsBetween - Milliseconds between two dates
• secondsBetween - Seconds between two dates
• minutesBetween - Minutes between two dates
• hoursBetween - Hours between two dates
• daysBetween - Days between two dates
• weeksBetween - Weeks between two dates

Add date function calls

• addMilliseconds - Add milliseconds to a date
• addSeconds - Add seconds to a date
• addMinutes - Add minutes to a date
• addHours - Add hours to a date
• addDays - Add days to a date
• addDaysUTC - Add days to a date using the UTC calendar
• addWeeks - Add weeks to a date
• addWeeksUTC - Add weeks to a date using the UTC calendar
• addMonths - Add months to a date
• addMonthsUTC - Add months to a date using the UTC calendar
• addYears - Add years to a date
• addYearsUTC - Add years to a date using the UTC calendar

Trim to date

• trimToSeconds - Trim to seconds
• trimToMinutes - Trim to minutes
• trimToHours - Trim to hours
• trimToHoursUTC - Trim to hours using the UTC calendar
• trimToDays - Trim to days
• trimToDaysUTC - Trim to days using the UTC calendar
• trimToMonths - Trim to months
• trimToMonthsUTC - Trim to months using the UTC calendar
• trimToYears - Trim to years
• trimToYearsUTC - Trim to years using the UTC calendar

To string

To float (deprecated)

Parse integer

Parse/format float function calls (deprecated)

• parseFloat - Convert a string to a float
• formatFloat - Convert a float to a string

Parse/format decimal function calls

• parseDecimal - Convert a string to a decimal
• formatDecimal - Convert a decimal to a string

Parse/format date function calls

• parseDateTime[UTC] - Convert a string to a date value
• formatDateTime[UTC] - Convert a date value to a string
• formatTime[UTC] - Convert the time part of a date value to a string
• formatDate[UTC] - Convert the date part of a date value to a string

Enumerations in expressions

• getCaption - Get caption of enumeration value in current language
• getKey - Get technical name of enumeration value