| Print Open PDF Version of Online Help

### Expression Builder Functions The following table lists the functions that you can use in Expression Builder. Click the name of a function to see more information about the function.
Boolean Functions | Date and Time Functions | String Functions | User Functions | Data Functions | Math Functions
--- | --- | --- | --- | --- | ---
IfNull | Duration | FieldValue | Locale | ExcludeChannel | LN
IIf | JulianDay | FindNoneOf | LocaleListSeparator | GetGroupId |
IsValidRowId | JulianMonth | FindOneOf | OrganizationName | JoinFieldValue |
| JulianQtr | HostName | UserValue | LookupName |
| JulianWeek | InStr |  | LookupValue |
| JulianYear | Left |  | PRE |
| Timestamp | Len |  | RowIdToRowNum |
| Today | Lower |  | RowNum |
| UtcConvert | Mid |  |  |
|  | Right |  |  |
|  | ToChar |  |  |
|  | Upper |  |  |
- Note the following information regarding other functions: Some of the functions listed in the drop-down list on the Functions field in Expression Builder are for internal use only. Do not use the following functions in your expressions: GetParentId IsManagerPosition Lookup LookupMessage LOVLanguage PositionId PositionName It is recommended that you use the UserValue function instead of the functions listed in the following table. These functions will become obsolete.
  Function | Recommended Alternative
  --- | ---
  Alias | UserValue('<Alias>')
  Currency | UserValue('<CurrencyCode>')
  DivisionName | UserValue('<Division>')
  FirstName | UserValue('<FirstName>')
  JobTitle | UserValue('<JobTitle>')
  Language | UserValue('<LanguageCode>')
  LanguageName | UserValue('<Language>')
  LastName | UserValue('<LastName>')
  LocalCurrency | UserValue('<CurrencyCode>')
  LocaleName | UserValue('<Locale>')
  LoginId | UserValue('<UserId>')
  LoginName | UserValue('<UserSignInId>')
#### Related Topics See the following topics for related Expression Builder information: About Expression Builder Using Expression Builder

Published 5/23/2022 | Copyright © 2005, 2022, Oracle and/or its affiliates. Legal Notices.