PickListValues
Contains predefined picklist values for fields across different Salesforce objects.
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 PickListValues WHERE TableName = 'Account' SELECT * FROM PickListValues WHERE TableName = 'Account' AND RecordTypeId = '0121W000000cq9EDAL'
Columns
| Name | Type | Description |
| ID [KEY] | String | A unique identifier for the picklist value, formatted as ColumnName|Picklist_Value. |
| TableName | String | The name of the Salesforce object (table) associated with the picklist. Required when retrieving picklist data. |
| ColumnName | String | The name of the column that the picklist is associated with. Optionally used to filter results to a specific column. |
| PickList_Value | String | The internal value stored in Salesforce for this picklist entry. |
| PickList_Label | String | The user-friendly label displayed in the Salesforce UI for the picklist value. |
| PickList_IsActive | Boolean | Indicates whether the picklist value is currently active and available for selection. |
| PickList_IsDefault | Boolean | Indicates whether this picklist value is set as the default for its associated column. |
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 | Optional identifier for the record type. Use this to return picklist values specific to a particular record type. |