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 PickListValues WHERE TableName = 'Account' SELECT * FROM PickListValues 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. |