JDBC Driver for Salesforce

Build 22.0.8462

PickListValues

This table lists picklist values for the specified TableName.

Table-Specific Information

Select

TableName should be specified in the WHERE clause. RecordTypeId may also be specified along TableName to only retrieve data for a specific record type.

SELECT * FROM Formulas WHERE TableName = 'Account'

SELECT * FROM Formulas WHERE TableName = 'Account' AND RecordTypeId = '0121W000000cq9EDAL'

Columns

Name Type Description
ID [KEY] String The unique identifier of the picklist in the format ColumnName|Picklist_Value.
TableName String The name of the table. This must be specified when retrieving data from PickListInformation.
ColumnName String The name of the column associated with the picklist entry. This may be optionally specified to only retrieve picklist information with regards to the specified column.
PickList_Value String The picklist value.
PickList_Label String The label for the picklist value.
PickList_IsActive Boolean A boolean indicating if the picklist value is active.
PickList_IsDefault Boolean A boolean indicating if this picklist value is the default value for the column it is associated with.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
RecordTypeId String The Id of the record type. Specify this to return values only for picklist fields of a record type.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462