TDV Adapter for Dynamics 365

Build 21.0.8137


Contains the Options Value of MultiSelect PicklistMetadata. Note: This view is only available when Edition is set to either CustomerService, FieldService, Marketing, ProjectOperations or Sales.


The adapter 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 adapter.

  • TableName supports '=','IN' operators.

For example, the following queries are processed server side:

SELECT * FROM MultiSelectPickListOptions where TableName = 'teams'

SELECT * FROM MultiSelectPickListOptions where TableName IN ('accounts','teams')


Name Type Description
ColumnName String
Color String
ExternalValue String
HasChanged String
IsManaged Boolean
Label_LocalizedLabels_HasChanged String
Label_LocalizedLabels_IsManaged Boolean
Label_LocalizedLabels_Label String
Label_LocalizedLabels_LanguageCode Integer
Label_LocalizedLabels_MetadataId String
Label_UserLocalizedLabel_HasChanged String
Label_UserLocalizedLabel_IsManaged Boolean
Label_UserLocalizedLabel_Label String
Label_UserLocalizedLabel_LanguageCode Integer
Label_UserLocalizedLabel_MetadataId String
Description_LocalizedLabels_HasChanged String
Description_LocalizedLabels_IsManaged Boolean
Description_LocalizedLabels_Label String
Description_LocalizedLabels_LanguageCode Integer
Description_LocalizedLabels_MetadataId String
Description_UserLocalizedLabel_HasChanged String
Description_UserLocalizedLabel_IsManaged Boolean
Description_UserLocalizedLabel_Label String
Description_UserLocalizedLabel_LanguageCode Integer
Description_UserLocalizedLabel_MetadataId String
MetadataId String
ParentValues String
Value Integer
TableName String

Copyright (c) 2022 CData Software, Inc. - All rights reserved.
Build 21.0.8137