PickListOptions
Stores option values for Picklist metadata attributes, providing details for enumerated selections. Only available when Edition is set to 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 | The name of the column representing the picklist attribute. |
| Color | String | The color associated with the picklist option, typically used for visual representation in the UI. |
| ExternalValue | String | An external value associated with the picklist option, useful for integration or mapping purposes. |
| HasChanged | String | Indicates whether the picklist option has been modified since its creation. |
| IsManaged | Boolean | Specifies whether the picklist option is part of a managed solution. |
| Label_LocalizedLabels | String | Localized labels providing display names for the picklist option in various languages. |
| Label_UserLocalizedLabel_HasChanged | String | Indicates whether the user-defined localized label for the picklist option has been modified. |
| Label_UserLocalizedLabel_IsManaged | Boolean | Specifies whether the user-defined localized label for the picklist option is managed. |
| Label_UserLocalizedLabel_Label | String | The actual text of the user-defined localized label for the picklist option. |
| Label_UserLocalizedLabel_LanguageCode | Integer | The language code associated with the user-defined localized label for the picklist option. |
| Label_UserLocalizedLabel_MetadataId | String | The unique identifier for the metadata of the user-defined localized label for the picklist option. |
| Description_LocalizedLabels | String | Localized labels providing descriptions for the picklist option in various languages. |
| Description_UserLocalizedLabel | String | The user-defined localized label for the description of the picklist option. |
| MetadataId | String | The unique identifier for the metadata of the picklist option. |
| ParentValues | String | The parent values associated with the picklist option, used when the option is part of a hierarchical structure. |
| Value | Integer | The numeric value assigned to the picklist option. |
| TableName | String | The name of the table containing the picklist attribute. |