UserValue Function
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_field_name>')
Result Type
String
Arguments
The following table describes the arguments for the function.
Argument
|
Description
|
attribute_field_name
|
The associated field name (that is, the corresponding XML name or customized integration tag) used to define the attributes of the current user.
|
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 attribute field names that can be used as arguments in the UserValue function, and their corresponding attributes.
Field Name
|
Attribute
|
Sample Value
|
Alias
|
Alias
|
Admin
|
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
|
Cell Phone #
|
+1 555 2368978
|
CreatedBy
|
Created By
|
Siebel CRM On Demand CSR Admin
|
CreatedDate
|
Created Date
|
09/04/2007 17:00:00
|
CurrencyCode
|
Currency
|
USD
|
Department
|
Department
|
Department
|
Division
|
Division
|
Division
|
EMailAddr
|
Email
|
john.doe@oracle.com
|
EmployeeNumber
|
Employee Number
|
12345
|
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
|
LanguageCode
|
Language Code
|
ENU
|
LastLoggedIn
|
Last Sign In
|
10/31/2007 19:39:01
|
LastName
|
Last Name
|
Doe
|
Locale
|
Locale
|
English - Canada
|
Market
|
Market
|
Market
|
MiddleName
|
Middle Name
|
Middle
|
MiscellaneousNumber1
|
Miscellaneous Number 1
|
|
MiscellaneousNumber2
|
Miscellaneous Number 2
|
|
MiscellaneousText1
|
Miscellaneous Text 1
|
DUNS # (Webcat) = 10461
|
MiscellaneousText2
|
Miscellaneous Text 2
|
a7cff064-6566-47a2-8629-8b32d92de222
|
ModifiedBy
|
Modified By
|
John Doe
|
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
|
PersonalAddressId
|
Address Id
|
AATA-HNCAU
|
PersonalCity
|
City
|
Toronto
|
PersonalCountry
|
Country
|
Canada
|
PersonalPostalCode
|
Postal Code
|
M4C2C3
|
PersonalProvince
|
Province
|
Ontario
|
PersonalStreetAddress
|
Number/Street
|
555 Main Avenue
|
PersonalStreetAddress2
|
Address 2
|
Suite 17
|
PhoneNumber
|
Work Phone #
|
+1 555 2365555
|
PrimaryGroup
|
Primary Group
|
User Group A
|
Region
|
Region
|
My Region
|
ManagerFullName
|
Reports To
|
John Smith
|
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
|
TimeZoneName
|
Time Zone
|
(GMT-05:00) Eastern Standard Time (US & Canada)
|
UserId
|
Row Id
|
1E1263-IZAU
|
UserSignInId
|
User Sign In ID
|
PTE169-14/ADMIN
|
WorkFax
|
Work Fax #
|
+1 555 2365556
|
Related Information
See the following topics for related Expression Builder information:
|