Tableau Connector for Dynamics 365 Sales

Build 21.0.7930

MultiSelectPickListAttributeMetaData

It Contains the Picklist metadata for an attribute type MultiSelect OptionSet.

Select

The connector will use the Dynamics 365 Sales 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

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_HasChanged String
OptionSet_Description_LocalizedLabels_IsManaged String
OptionSet_Description_LocalizedLabels_Label String
OptionSet_Description_LocalizedLabels_LanguageCode String
OptionSet_Description_LocalizedLabels_MetadataId 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_HasChanged String
OptionSet_DisplayName_LocalizedLabels_IsManaged String
OptionSet_DisplayName_LocalizedLabels_Label String
OptionSet_DisplayName_LocalizedLabels_LanguageCode String
OptionSet_DisplayName_LocalizedLabels_MetadataId 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) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930