MultiSelectPickListOptions
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.
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 MultiSelectPickListOptions WHERE TableName = 'teams'
SELECT * FROM MultiSelectPickListOptions WHERE TableName IN ('accounts', 'teams')
Columns
| Name | Type | Description |
| ColumnName | String | |
| Color | String | |
| ExternalValue | String | |
| HasChanged | String | |
| IsManaged | Boolean | |
| Label_LocalizedLabels | String | |
| Label_UserLocalizedLabel_HasChanged | String | |
| Label_UserLocalizedLabel_IsManaged | Boolean | |
| Label_UserLocalizedLabel_Label | String | |
| Label_UserLocalizedLabel_LanguageCode | Integer | |
| Label_UserLocalizedLabel_MetadataId | String | |
| Description_LocalizedLabels | 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 |