PickListAttributeMetaData
Contains the metadata for an attribute type Picklist. Note: This view is only available when Edition is set to either CustomerService, FieldService, Marketing, ProjectOperations or Sales.
Select
The driver will use the Microsoft Dynamics 365 API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the driver.
- TableName supports '=','IN' operators.
For example, the following queries are processed server side:
SELECT * FROM PickListAttributeMetaData WHERE TableName = 'teams' SELECT * FROM PickListAttributeMetaData WHERE TableName IN ('accounts', 'teams')
Columns
Name | Type | Description |
ColumnName [KEY] | String | |
MetadataId | String | |
OptionSet_Description_LocalizedLabels | String | |
OptionSet_Description_UserLocalizedLabel_HasChanged | String | |
OptionSet_Description_UserLocalizedLabel_IsManaged | Boolean | |
OptionSet_Description_UserLocalizedLabel_Label | String | |
OptionSet_Description_UserLocalizedLabel_LanguageCode | Integer | |
OptionSet_Description_UserLocalizedLabel_MetadataId | String | |
OptionSet_DisplayName_LocalizedLabels | String | |
OptionSet_DisplayName_UserLocalizedLabel_HasChanged | String | |
OptionSet_DisplayName_UserLocalizedLabel_IsManaged | Boolean | |
OptionSet_DisplayName_UserLocalizedLabel_Label | String | |
OptionSet_DisplayName_UserLocalizedLabel_LanguageCode | Integer | |
OptionSet_DisplayName_UserLocalizedLabel_MetadataId | String | |
OptionSet_ExternalTypeName | String | |
OptionSet_HasChanged | String | |
OptionSet_IntroducedVersion | String | |
OptionSet_IsCustomizable_CanBeChanged | Boolean | |
OptionSet_IsCustomizable_ManagedPropertyLogicalName | String | |
OptionSet_IsCustomizable_Value | Boolean | |
OptionSet_IsCustomOptionSet | Boolean | |
OptionSet_IsGlobal | Boolean | |
OptionSet_IsManaged | Boolean | |
OptionSet_MetadataId | String | |
OptionSet_Name | String | |
OptionSet_OptionSetType | String | |
OptionSet_ParentOptionSetName | String | |
TableName | String |