To use Adobe LiveCycle Business Activity Monitoring ES2 (v.9) product documentation, you must enable JavaScript in your browser.

Salesforce Picklist Function

In addition to the flatten function, there is also a picklist function available for use with Salesforce agents. The picklist function returns a single column dataset of the possible values for a picklist typed column in Salesforce.

Syntax

The flattening function has the following syntax:

PICKLIST( tableName,pickListColumn )
Parameters

The parameters of the function are defined as follows:

Remarks

You must have data caching with prefetch enabled in your lookup table for the picklist function to work properly. See Caching Lookup Table Queries for details about enabling caching.

The column to return must be a picklist typed column.

Example

The following picklist function returns the dataset of possible values from the LeadSource column in the Opportunity table.

picklist(opportunity,leadsource)

The illustration below shows the Opportunity table.

The picklist function retrieves the LeadSource column.