PickListAttributeMetaData
Holds metadata for attributes of the Picklist type, detailing their options and configuration. Only available when Edition is set to 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 | The name of the column representing the picklist attribute within the table. |
| MetadataId | String | The unique identifier for the metadata of the picklist attribute. |
| OptionSet_Description_LocalizedLabels | String | Localized labels providing descriptions for the option set in various languages. |
| OptionSet_Description_UserLocalizedLabel_HasChanged | String | Indicates if the user-defined localized label for the description has been modified. |
| OptionSet_Description_UserLocalizedLabel_IsManaged | Boolean | Specifies whether the user-defined localized label for the description is managed. |
| OptionSet_Description_UserLocalizedLabel_Label | String | The actual text of the user-defined localized label for the description. |
| OptionSet_Description_UserLocalizedLabel_LanguageCode | Integer | The language code associated with the user-defined localized label for the description. |
| OptionSet_Description_UserLocalizedLabel_MetadataId | String | The unique identifier for the metadata of the user-defined localized label for the description. |
| OptionSet_DisplayName_LocalizedLabels | String | Localized labels providing display names for the option set in various languages. |
| OptionSet_DisplayName_UserLocalizedLabel_HasChanged | String | Indicates if the user-defined localized label for the display name has been modified. |
| OptionSet_DisplayName_UserLocalizedLabel_IsManaged | Boolean | Specifies whether the user-defined localized label for the display name is managed. |
| OptionSet_DisplayName_UserLocalizedLabel_Label | String | The actual text of the user-defined localized label for the display name. |
| OptionSet_DisplayName_UserLocalizedLabel_LanguageCode | Integer | The language code associated with the user-defined localized label for the display name. |
| OptionSet_DisplayName_UserLocalizedLabel_MetadataId | String | The unique identifier for the metadata of the user-defined localized label for the display name. |
| OptionSet_ExternalTypeName | String | The external type name associated with the option set, if applicable. |
| OptionSet_HasChanged | String | Indicates whether the option set has been modified since its creation. |
| 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. |
| OptionSet_IsCustomizable_ManagedPropertyLogicalName | String | The logical name of the managed property that defines whether the option set is customizable. |
| OptionSet_IsCustomizable_Value | Boolean | Specifies if the option set is marked as customizable. |
| OptionSet_IsCustomOptionSet | Boolean | Specifies if the option set is custom or predefined. |
| OptionSet_IsGlobal | Boolean | Indicates whether the option set is global (shared across entities) or local to a specific entity. |
| OptionSet_IsManaged | Boolean | Specifies if the option set is part of a managed solution. |
| OptionSet_MetadataId | String | The unique identifier for the metadata of the option set. |
| OptionSet_Name | String | The name of the option set. |
| OptionSet_OptionSetType | String | The type of the option set, defining its structure and usage. |
| OptionSet_ParentOptionSetName | String | The name of the parent option set if the current option set is part of a hierarchical structure. |
| TableName | String | The name of the table containing the picklist attribute. |