PickListAttributeMetaData
Holds metadata for attributes of type Picklist, describing the single-option selection fields in the system.
ビュー固有の情報
Select
connector はMicrosoft Dataverse API を使用して、以下のカラムと演算子で作成されたWHERE 句条件を処理します。その他のフィルタはクライアントサイドでconnector 内部で処理されます。
- TableName は'='、'IN' 演算子をサポートしています。
TableName でフィルタリングしない場合、connector は最初に見つかったテーブルの結果を返します。
例えば、次のクエリはサーバーサイドで処理されます。
SELECT * FROM PickListAttributeMetaData WHERE TableName = 'teams'
SELECT * FROM PickListAttributeMetaData WHERE TableName IN ('accounts', 'teams')
Columns
| Name | Type | References | Description |
| ColumnName [KEY] | String | The name of the column in the table where the picklist attribute is defined. | |
| MetadataId | String | The unique identifier for the metadata associated with this attribute. | |
| OptionSet_Description_LocalizedLabels | String | Localized descriptions of the options in the picklist for various supported languages. | |
| OptionSet_Description_UserLocalizedLabel_HasChanged | String | Indicates whether the user-customized description label has been modified. | |
| OptionSet_Description_UserLocalizedLabel_IsManaged | Boolean | Specifies if the user-customized description label is managed (part of a managed solution). | |
| OptionSet_Description_UserLocalizedLabel_Label | String | The localized label text for the description of the picklist. | |
| OptionSet_Description_UserLocalizedLabel_LanguageCode | Integer | The language code associated with the user-localized description label. | |
| OptionSet_Description_UserLocalizedLabel_MetadataId | String | The unique identifier for the metadata of the user-localized description label. | |
| OptionSet_DisplayName_LocalizedLabels | String | Localized display names for the picklist options in various languages. | |
| OptionSet_DisplayName_UserLocalizedLabel_HasChanged | String | Indicates whether the user-customized display name label has been modified. | |
| OptionSet_DisplayName_UserLocalizedLabel_IsManaged | Boolean | Specifies if the user-customized display name label is managed (part of a managed solution). | |
| OptionSet_DisplayName_UserLocalizedLabel_Label | String | The localized label text for the display name of the picklist. | |
| OptionSet_DisplayName_UserLocalizedLabel_LanguageCode | Integer | The language code associated with the user-localized display name label. | |
| OptionSet_DisplayName_UserLocalizedLabel_MetadataId | String | The unique identifier for the metadata of the user-localized display name label. | |
| OptionSet_ExternalTypeName | String | The external type name associated with the option set, if applicable. | |
| OptionSet_HasChanged | String | Indicates if the option set has been modified since its creation or last update. | |
| OptionSet_IntroducedVersion | String | The version of the system in which the option set was introduced. | |
| OptionSet_IsCustomizable_CanBeChanged | Boolean | Indicates whether the option set can be customized by the user or administrators. | |
| OptionSet_IsCustomizable_ManagedPropertyLogicalName | String | The logical name of the managed property controlling customizability of the option set. | |
| OptionSet_IsCustomizable_Value | Boolean | Specifies if the option set is customizable. | |
| OptionSet_IsCustomOptionSet | Boolean | Indicates whether the option set is custom or part of a default configuration. | |
| OptionSet_IsGlobal | Boolean | Specifies if the option set is global (shared across entities) or local (specific to one entity). | |
| OptionSet_IsManaged | Boolean | Indicates if the option set is managed (part of a managed solution). | |
| OptionSet_MetadataId | String | The unique identifier for the metadata associated with the option set. | |
| OptionSet_Name | String | The name of the option set. | |
| OptionSet_OptionSetType | String | The type of the option set (e.g., picklist, drop-down). | |
| OptionSet_ParentOptionSetName | String | The name of the parent option set, if this option set is part of a hierarchy. | |
| TableName | String | The name of the table where the picklist attribute is defined. |