Print      Open PDF Version of Online Help

Administering Oracle CRM On Demand > Expression Builder > Expression Builder Functions > ExcludeChannel

ExcludeChannel

The ExcludeChannel function in Expression Builder returns FALSE if the specified channel name is the channel that the request came from.

Syntax

ExcludeChannel(channel name)

Result Type

Boolean

Arguments

The following table describes the arguments for the function.

The following table describes the valid strings for use in the channel name argument. The strings are case-sensitive.

Examples

The following example stops a process from being triggered by a Web service request:

ExcludeChannel("Web Services")

The following example stops a process from being triggered by an import operation or Oracle Data Loader On Demand:

ExcludeChannel("Import")

Example of Allowing Specified Online Updates

When the Online channel string is specified with the ExcludeChannel function, updates from the following channels are prevented:

• All user interactions in browser windows, including updates performed through the Mass Update functionality and record merges
• REST API calls

If you want to allow updates from REST API calls, or the Mass Update functionality, or record merges, but you want to prevent updates from other user interactions in browser windows, then use the IIF function with the ExcludeChannel function to specify the online channels that you want to allow. For example, to allow updates to account records by REST API calls and prevent updates to account records from user interactions in browser windows, including the Mass Update functionality and record merges, you can create a workflow rule with the following configuration:

• The record type is Account.
• The trigger event is Before Modified Record Saved.
• The Cancel Save check box is selected.
• The condition is as follows:

  IIf(ExcludeChannel("Online"),1,IIf(ExcludeChannel("Rest"),0,1))

This workflow rule allows updates from all channels that are not prevented by the Online channel string, such as Web services and the import functionality, as well as updates from REST API calls.

NOTE: When combining the ExcludeChannel function with another function as shown in this example, remember that the ExcludeChannel function returns a FALSE value if the specified channel name is the channel that the request came from.

Related Topics

See the following topics for related Expression Builder information:

• About Expression Builder
• Using Expression Builder
• Expression Builder Functions