Tableau Connector for Certinia

Build 23.0.8839

PickListValues

This table lists picklist values for the specified TableName.

Columns

Name Type Description
ID [KEY] String The unique identifier of the picklist in the format ColumnName|Picklist_Value.
TableName String The name of the table. This must be specified when retrieving data from PickListInformation.
ColumnName String The name of the column associated with the picklist entry. This may be optionally specified to only retrieve picklist information with regards to the specified column.
PickList_Value String The picklist value.
PickList_Label String The label for the picklist value.
PickList_IsActive Boolean A boolean indicating if the picklist value is active.
PickList_IsDefault Boolean A boolean indicating if this picklist value is the default value for the column it is associated with.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
RecordTypeId String The Id of the record type. Specify this to return values only for picklist fields of a record type.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839