Print      Open PDF Version of Online Help


Previous Topic

Next Topic

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

InStr

UserValue

LookupName

 

 

JulianWeek

Left

 

LookupValue

 

 

JulianYear

Len

 

PRE

 

 

Timestamp

Lower

 

RowIdToRowNum

 

 

Today

Mid

 

RowNum

 

 

UtcConvert

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:


Published 1/9/2017 Copyright © 2005, 2017, Oracle. All rights reserved. Legal Notices.