Administering Oracle CRM On Demand > Expression Builder > Expression Builder Functions > UserValue
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.
Integration tags are displayed in the Integration Tag Web Services v2.0 column in the record type Fields page.
|
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
|
PrimaryDivisionName
|
Primary Division
|
Asia Division
|
PrimaryGroup
|
Primary Group
|
User Group A
|
PrimaryPvgName
|
Not available
NOTE: The PrimaryPvgName attribute returns the name of the picklist value group that is associated with the user's primary division.
|
India PVG
|
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:
|