| Print Open PDF Version of Online Help

#### 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.
Argument | Description
--- | ---
channel name | The name of the channel to be excluded.
The following table describes the valid strings for use in the channel name argument. The strings are case-sensitive.
Channel Name String | Description
--- | ---
Import | This channel string excludes updates performed through the import functionality and through Oracle Data Loader On Demand.
Online | This channel string excludes updates performed by: User interactions in browser windows, including updates from the Mass Update functionality and record merges REST API calls NOTE: The Online channel string does not exclude updates performed through the import functionality.
Mass Update | This channel string excludes updates performed through the Mass Update functionality only. NOTE: Updates performed through the Mass Update functionality are also excluded by the Online channel string.
Record Merge | This channel string excludes updates performed by record merges only. NOTE: Updates from record merges are also excluded by the Online channel string.
Web Services | This channel string excludes updates from Web services.
Office | This channel string excludes updates from Oracle CRM On Demand Integration for Office.
OEI | This channel string excludes updates from Oracle Outlook Email Integration On Demand and Oracle Notes Email Integration On Demand.
Desktop | This channel string excludes updates from Oracle CRM On Demand Desktop.
Rest | This channel string excludes updates from REST API calls only. NOTE: Updates from REST API calls are also excluded by the Online channel string.
Mobile | This channel string excludes updates from Oracle CRM On Demand Connected Mobile Sales.
### 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

Published 5/23/2022 | Copyright © 2005, 2022, Oracle and/or its affiliates. Legal Notices.