Standard Functions

This table lists the standard functions that you can use when defining rules.

Name

Variable Type

Description

Values

Contains

Boolean

Returns True if the field provided as parameter #1 contains the characters provided as parameter #2, else returns False.

These 2 parameters are provided for the function.

  • Field

  • Characters

True or False

Convert decimal to long

Decimal

Returns a long converted from a decimal.

N/a

Convert decimal to string

String

Returns a string converted from a decimal.

N/A

Convert integer to long

Decimal

Returns a long converted from an integer

N/A

Convert integer to string

String

Returns a string converted from an integer.

N/A

Convert long to string

String

Returns a string converted from a long.

N/A

Convert string to number

Integer

Returns a number converted from a string.

N/A

Day of

Integer

Returns the day from a given date as a number between 1 and 31.

N/A

Ends with

Boolean

Returns True if the field provided as parameter #1 ends with the characters provided as parameter #2, else returns False.

These 2 parameters are provided for the function.

  • Field

  • Characters

True or False

Get date in custom format

String

Returns a date format such as:

  • Year: 2020

  • Day of the week: Thu

  • Day of the week: where 1 = Monday, 2 = Tuesday, and so on

These are the 2 parameters for the function

  • Date

  • Time pattern, date pattern, or combination of both

Expression Example

  • Variable type for the date format needs to be a string

  • For the date 17 Jun 2020,

    • E returns day of the week: Thu

    • u returns day of the week: 4

Values for time pattern, date pattern, or a combination of both are listed on the Oracle Help Center at docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html

Get first row

Row

Returns values for the first row. This function is commonly used.

N/A

Get last row

Row

Returns values for the last row. This function is rarely used.

N/A

Index of

Integer

Returns a number representing the index of the first occurrence of the character in the string, or -1 if it never occurs.

These 2 parameters are provided for the function.

  • A string value representing the string to search in.

  • A string value representing the string to search for.

N/A

Is another row present

Boolean

Returns True if the business object provided as a parameter has more than the current row, else returns False.

True or False

Is modified field

Boolean

Returns True if the field provided as parameter is modified, else returns False.

True or False

Length of

Integer

Returns the number of characters in a string.

N/A

Lowercase of

String

Returns the string in lower case.

N/A

Month of

Integer

Returns the month from a given date as a number between 1 and 12.

N/A

Starts with

Boolean

Returns True if the field provided as parameter #1 starts with the characters provided as

These 2 parameters are provided for the function.

  • Field

  • Characters

True or False

Today's date

Date

Returns the current date.

N/A

Uppercase of

String

Returns the string in upper case.

N/A

User role

Boolean

Returns True if the logged in user has the role provided as parameter, else returns False.

True or False

Year of

Integer

Returns the year of a date.

N/A