JDBC Driver for Microsoft Dynamics 365 Sales

Build 22.0.8257

PickListOptions

Contains the Options value of PickListMetaData

Select

The {i will use the Microsoft 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 {i.

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

For example, the following queries are processed server side:

SELECT * FROM PickListOptions

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

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