Built-in Functions
Built-in functions can be used in various places:
- As parameters for search and dashboard queries.
- As values or expression members in quick actions.
- As values or expression members in object and relationship rules.
- As values in workflow objects.
- As values in reports.
Each function description contains the following information:
- Name of the function.
- Brief description of the function.
- Syntax of the function.
- The business objects for which this function is enabled: Search/dashboard, business rules, quick actions, workflow objects, and reports.
- Input parameters for the function. These inputs can be literals, field references, function calls, text concatenation, expressions, and so on. For details on expressions, see Expressions.
- The type of value that the function returns. Possible values are as follows:
- Text
- DateTime
- Boolean
- Number
- Unicode text
- Fixed text
- Currency
- List of text items (only valid in certain areas)
- Regular expression
- An example of how the function is used.
The following functions are described in this section:
Current User Functions
CurrentLoginId |
|
CurrentUserDisplayName |
|
CurrentUserEmail |
|
CurrentUserField |
|
CurrentUserIdentityType |
|
CurrentUserInfo1 |
|
CurrentUserName |
|
CurrentUserOrganizationalUnitName |
|
CurrentUserOrganizationalUnit |
|
CurrentUserRecId |
|
CurrentUserRelatedObjectFieldValues |
|
CurrentUserRole |
|
CurrentUserTeam |
|
CurrentUserTeamIds |
|
CurrentUserTeamNames |
|
UserPresence |
|
Date Functions
AddDays |
|
AddHours |
|
AddMinutes |
|
AddMonths |
|
AddQuarters |
|
AddWeeks |
|
AddYears |
|
BeginningOfDay |
|
BeginningOfHour |
|
BeginningOfMinute |
|
BeginningOfMonth |
|
BeginningOfQuarter |
|
BeginningOfWeek |
|
BeginningOfYear |
|
CurrentDate |
|
CurrentDateStr |
|
CurrentDateTime |
|
DateAdd |
|
DateDiff |
|
DatePart |
|
EndOfDay |
|
EndOfHour |
|
EndOfMinute |
|
EndOfMonth |
|
EndOfNextYear |
|
EndOfQuarter |
|
EndOfThisMonth |
|
EndOfThisYear |
|
EndOfWeek |
|
EndOfYear |
|
FormatDate |
|
Last3Months |
|
Last90Days |
|
Last365Days |
|
LastDays |
|
LastSevenDays |
|
LastThirtyDays |
|
LastWeeks |
|
LastYears |
|
NextDays |
|
NextSevenDays |
|
SecondsToTime |
|
StartOfNextYear |
|
StartOfPreviousMonth |
|
StartOfThisMonth |
|
StartOfThisYear |
|
ToClientTime |
|
Today |
|
Tomorrow |
|
Yesterday |
|
System Functions
IsModuleEnabled |
|
AuditHistoryDescription |
|
CurrentBrowserCulture |
|
CurrentBrowserTimezoneOffset |
|
CurrentGlobalCurrency |
|
EncodeLink |
|
EvalField |
|
GetActionVariable |
|
GetApplicationId |
|
GetCounterValue |
|
GetGlobal |
|
GetNextCounter |
|
GetSurveyName |
|
GetSurveyURL |
|
GetUserAnnotatedField |
|
GetUserField |
|
HOPCalcDuration |
|
HOPCalcTargetDate |
|
HtmlDecode |
|
HtmlEncode |
|
HtmlSanitize |
|
IsNull |
|
Local |
|
NewGuid |
|
nvl |
|
Prompt |
|
PromptAndExecuteAction |
|
SecureServerURL |
|
ServerURL |
|