Contains predefined picklist values for fields across different Salesforce objects.

ビュー固有の情報

SELECT

TableName はWHERE 句で指定する必要があります。RecordTypeId をTableName と併せて指定して、特定のレコードタイプのデータのみを取得することもできます。

SELECT * FROM PickListValues WHERE TableName = 'Account'

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

Columns

Name	Type	References	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.

Pseudocolumns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるデータを詳細に制御することができます。

Name	Type	Description
RecordTypeId	String		Optional identifier for the record type. Use this to return picklist values specific to a particular record type.