PickListOptions
Contains the Options value of 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 PickListOptions WHERE TableName = 'teams'
SELECT * FROM PickListOptions 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 | String | |
| MetadataId | String | |
| ParentValues | String | |
| Value | Integer | |
| TableName | String |