JDBC Driver for Microsoft Dataverse

Build 24.0.9175

MultiSelectPickListOptions

Contains the possible selectable options for MultiSelect OptionSet attributes, enabling multi-value selections.

ビュー固有の情報

Select

本製品 はMicrosoft Dataverse API を使用して、以下のカラムと演算子で作成されたWHERE 句条件を処理します。その他のフィルタはクライアントサイドで本製品 内部で処理されます。

  • TableName は'='、'IN' 演算子をサポートしています。

TableName でフィルタリングしない場合、本製品 は最初に見つかったテーブルの結果を返します。

例えば、次のクエリはサーバーサイドで処理されます。

SELECT * FROM MultiSelectPickListOptions WHERE TableName = 'teams'

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

Columns

Name Type References Description
ColumnName String

MultiSelectPickListAttributeMetaData.ColumnName

The name of the column in the table where the multi-select picklist option is defined.
Color String The color code associated with the picklist option, often used for UI display purposes.
ExternalValue String An external system value mapped to this picklist option, if applicable.
HasChanged String Indicates whether the option has been modified since its creation or last update.
IsManaged Boolean Specifies if the picklist option is managed (part of a managed solution).
Label_LocalizedLabels String Localized labels for the picklist option in different languages.
Label_UserLocalizedLabel_HasChanged String Indicates if the user-customized label for the picklist option has been modified.
Label_UserLocalizedLabel_IsManaged Boolean Specifies if the user-customized label for the picklist option is managed.
Label_UserLocalizedLabel_Label String The user-customized label text for the picklist option.
Label_UserLocalizedLabel_LanguageCode Integer The language code corresponding to the user-customized label.
Label_UserLocalizedLabel_MetadataId String The unique identifier for the metadata of the user-customized label.
Description_LocalizedLabels String Localized descriptions for the picklist option in different languages.
Description_UserLocalizedLabel_HasChanged String Indicates if the user-customized description for the picklist option has been modified.
Description_UserLocalizedLabel_IsManaged Boolean Specifies if the user-customized description for the picklist option is managed.
Description_UserLocalizedLabel_Label String The user-customized description text for the picklist option.
Description_UserLocalizedLabel_LanguageCode Integer The language code corresponding to the user-customized description.
Description_UserLocalizedLabel_MetadataId String The unique identifier for the metadata of the user-customized description.
MetadataId String The unique identifier for the metadata associated with the picklist option.
ParentValues String Specifies the parent values for hierarchical picklist options, if applicable.
Value Integer The integer value associated with this picklist option, used for storage and retrieval.
TableName String The name of the table where this picklist option is defined.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 24.0.9175