Print      Open PDF Version of Online Help

Previous Topic

Next Topic

Using Expression Builder

In Oracle CRM On Demand, you can use Expression Builder wherever you see the fx icon beside a text box. Clicking the icon opens Expression Builder in a separate window.

To build an expression

  1. Click the fx icon to open Expression Builder.
  2. In Expression Builder, select the fields and functions from the lists, or type in the expression editor.

    When you select a field from the list, the field is pasted in to the expression editor. For example, when you select CloseDate from the list of Opportunity fields, [<CloseDate>] is pasted into the expression editor.

    NOTE: If your company administrator has renamed a field, the Fields picklist shows the new field name. However, the original field name (that is, the corresponding XML name) is pasted into the expression editor.

    The brackets around the field name indicate that the value of the particular field will be evaluated and returned in its specific data type. See the following table for more information about selecting fields and field values.

  3. Edit the expression by adding operators and literals as needed.

    NOTE: If you want your expression to determine whether a picklist field has a certain value, do not type the value in the expression. For example, do not type [<AccountType>] = "Customer". Instead, select the picklist field from the list, and click the Show Acceptable Values link in Expression Builder. Select the value that you want to use in the expression from the values shown. The expression looks something like the following:

    [<AccountType>]=LookupValue("ACCOUNT_TYPE", "Customer")

  4. (Optional) Click Check Syntax, and then make any corrections.
  5. Save your expression.

The following table describes Expression Builder.

Interface Element


record type Fields

Provides a context-specific picklist of the fields (from the context record type) that are allowed in an expression. If your company administrator has renamed some fields, the Fields picklist shows the new field names.

Note the following points:

  • If you are creating a workflow rule, or actions related to a workflow rule, the context record type is the record type specified in the definition of the workflow rule. For example, if you are creating the body of an email that is to be sent as an action on a workflow rule for a service request record, the context record type for Expression Builder is Service Request.
  • In advanced field management, the context record type is the record type that is the parent of the field where the expression is being created. For example, when defining field validation on an opportunity field, the context record type for Expression Builder is Opportunity.

Show Acceptable Values

When you have selected a field from the Fields picklist, click Show Acceptable Values to display the acceptable values for that field.

  • If the selected field is a picklist field, Show Acceptable Values displays all the options configured for that picklist.

    You can select only one option at a time. Selecting an option results in the definition of a Lookup function that can be used in an expression.

  • If the selected field is not a picklist field, Show Acceptable Values displays a window that describes the acceptable values for a variety of data that the field can hold.


Provides a drop-down list of the special functions that are available to modify, extract, or process data within an expression. For a list of the available functions, see Expression Builder Functions.


A multiline editable text box that displays the expression.

For information about the maximum supported length of an expression, see About Expressions.

Fields and functions that you select from the picklists appear in the expression editor. You can also type expressions directly in the expression editor.

The expression syntax always displays the language-independent field names. (A language-independent name is a name that does not change when the user language changes.) For custom fields, field names appear in the expression with integration tags affixed to the language-independent names.

Syntax Guide

Displays the Expression Builder topic in Oracle CRM On Demand online help.

Sample Expressions

Displays the following topic, Expression Builder Examples, in Oracle CRM On Demand online help.

Check Syntax

Validates the syntax of the expression that you created.


Saves the expression.


Closes the Expression Builder window without saving any changes.

Related Topics

See the following topics for related Expression Builder information:

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