Print      Open PDF Version of Online Help


Previous Topic

Next Topic

UserValue

The UserValue function in Expression Builder returns the value of a specified attribute for the current user.

The fields on the User Detail view are attributes of the selected user.

Syntax

UserValue('<attribute>')

Result Type

String

Arguments

The following table describes the arguments for the function.

Argument

Description

attribute

The language-independent name or customized integration tag that corresponds to the display name of the current user attribute.

Examples

Example1: A business process requires that a custom text field called Origin on a service request is to display by default the country of the user who creates the record (the current user) when the record is created.

To implement the business rule, in the Field Setup page for service requests, set the default value for the Origin field to UserValue('<PersonalCountry>'), and select the Post Default check box.

For information about creating and editing fields, see Creating and Editing Fields.

Example 2: A business process requires that a certain workflow rule is triggered if the owner of an opportunity is not the administrator.

To implement the business rule, set up the following condition on the workflow rule:

UserValue('<EMailAddr>') <> 'administrator@testdata.com'

Attributes

The following table lists the attributes that can be used as arguments in the UserValue function, and their corresponding display names.

Attribute

Display Name

Sample Value

Alias

Alias

Admin

AuthenticationType

Authentication Type

User ID/Password Only

BusinessUnit

Business Unit

Business Unit

BusinessUnitLevel1

Business Unit Level 1

Business Unit L1

BusinessUnitLevel2

Business Unit Level 2

Business Unit L2

BusinessUnitLevel3

Business Unit Level 3

Business Unit L3

BusinessUnitLevel4

Business Unit Level 4

Business Unit L4

CellPhone

Cellular Phone #

+1 555 2368978

CreatedBy

Created By

Oracle CRM On Demand CSR Admin

CreatedById

Not available

1E1263-IZBZ

CreatedDate

Created Date

01/08/2007 21:21:33

CurrencyCode

Currency

USD

Department

Department

Department

Division

Division

Division

EMailAddr

Email

john.doe@oracle.com

EmployeeNumber

Employee Number

12345

EnableTeamContactsSync

Enable Sync of Team Contacts

Y

ExternalIdentifierForSingleSignOn

External Identifier for Single Sign-On

UID=ADMIN,O=ORACLE

 

ExternalSystemId

External Unique ID

EXTUID123

FirstName

First Name

John

FundApprovalLimit

Fund Approval Limit

50000

IntegrationId

Integration ID

INTUID123

JobTitle

JobTitle

Product Manager

Language

Language

English-American

LastLoggedIn

Last Sign In

10/31/2007 19:39:01

LastName

Last Name

Doe

LeadLimit

Lead Limit

2345679

Locale

Locale

English - Canada

ManagerFullName

Reports To

John Smith

ManagerId

Not available

1E4763-IZAU

Market

Market

Market

MiddleName

Middle Name

Middle

MiscellaneousNumber1

Miscellaneous Number 1

2312

MiscellaneousNumber2

Miscellaneous Number 2

2312

MiscellaneousText1

Miscellaneous Text 1

DUNS # (Webcat) = 10461

MiscellaneousText2

Miscellaneous Text 2

a7cff064-6566-47a2-8629-8b32d92de222

ModifiedBy

Modified By

John Doe

ModifiedById

Not available

1E1263-IZBZ

ModifiedDate

Modified Date

10/31/2007 19:32:58

MrMrs

Mr./Ms.

Mr.

NeverCall

Never Call

Y

NevereMail

Never Email

Y

NeverMail

Never Mail

Y

PasswordState

Password State

Active

PersonalCity

City

Toronto

PersonalCountry

Country

Canada

PersonalPostalCode

Postal Code

M4C2C3

PersonalProvince

Province

Ontario

PersonalState

State/Province

CA

PersonalStreetAddress

Street

555 Main Avenue

PersonalStreetAddress2

Address 2

Suite 17

PersonalStreetAddress3

Address 3

Scarborough

PhoneNumber

Work Phone #

+1 555 2365555

PrimaryGroup

Primary Group

User Group A

Region

Region

My Region

Role

Role

Field Sales Rep

RoleId

Role Id

1E1263-IYG1

SecondaryEmail

Secondary Email

john.doe2@oracle.com

ShowWelcomePage

Show Welcome Page on Sign In

N

Status

Status

Active

SubMarket

Submarket

My submarket

SubRegion

Subregion

My sub region

TempPasswordFlag

Email Temporary Password When I Click Save

Y

TimeZoneName

Time Zone

(GMT-05:00) Eastern Standard Time (US & Canada)

UserId

Row Id

1E1263-IZAU

UserLoginId

Row Id

1E1263-IZAU

UserSignInId

User Sign In ID

PTE169-14/ADMIN

WorkFax

Work Fax #

+1 555 2365556

Related Topics

See the following topics for related Expression Builder information:


Published 5/4/2012 Copyright © 2005, 2012, Oracle. All rights reserved. Legal Notices.