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 connector 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 connector.
- 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 |