Tableau Connector for Microsoft Dynamics 365

Build 22.0.8462

MultiSelectPickListAttributeMetaData

Contains the Picklist metadata for an attribute type MultiSelect OptionSet. 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 MultiSelectPickListAttributeMetaData WHERE TableName = 'teams'

SELECT * FROM MultiSelectPickListAttributeMetaData 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

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462