PickListOptions
Defines the set of selectable options available for Picklist attributes, supporting user-defined field values.
ビュー固有の情報
Select
本製品 はMicrosoft Dataverse API を使用して、以下のカラムと演算子で作成されたWHERE 句条件を処理します。その他のフィルタはクライアントサイドで本製品 内部で処理されます。
- TableName は'='、'IN' 演算子をサポートしています。
TableName でフィルタリングしない場合、本製品 は最初に見つかったテーブルの結果を返します。
例えば、次のクエリはサーバーサイドで処理されます。
SELECT * FROM PickListOptions WHERE TableName = 'teams'
SELECT * FROM PickListOptions WHERE TableName IN ('accounts', 'teams')
Columns
| Name | Type | References | Description |
| ColumnName | String |
PickListAttributeMetaData.ColumnName | The name of the column in the table where the picklist option is defined. |
| Color | String | The color code associated with the picklist option, often used for display purposes in user interfaces. | |
| ExternalValue | String | An external value associated with this picklist option, used for integration with external systems. | |
| HasChanged | String | Indicates whether the picklist option has been modified since its creation or last update. | |
| IsManaged | Boolean | Specifies if the picklist option is managed (part of a managed solution). | |
| Label_LocalizedLabels | String | Localized labels for the picklist option in multiple languages. | |
| Label_UserLocalizedLabel_HasChanged | String | Indicates if the user-customized label for the picklist option has been modified. | |
| Label_UserLocalizedLabel_IsManaged | Boolean | Specifies if the user-customized label for the picklist option is managed (part of a managed solution). | |
| Label_UserLocalizedLabel_Label | String | The user-customized label text for the picklist option. | |
| Label_UserLocalizedLabel_LanguageCode | Integer | The language code corresponding to the user-customized label. | |
| Label_UserLocalizedLabel_MetadataId | String | The unique identifier for the metadata associated with the user-customized label. | |
| Description_LocalizedLabels | String | Localized descriptions for the picklist option in various supported languages. | |
| Description_UserLocalizedLabel | String | The user-customized description for the picklist option, providing additional context or meaning. | |
| MetadataId | String | The unique identifier for the metadata associated with this picklist option. | |
| ParentValues | String | Specifies the parent values for hierarchical picklist options, if applicable. | |
| Value | Integer | The integer value associated with this picklist option, used for storage and retrieval. | |
| TableName | String | The name of the table where this picklist option is defined. |