ODBC Driver for Workday

Build 25.0.9434

ExpandIDTypes

Display one column per ID type when a report contains multiple ID types.

データ型

bool

デフォルト値

false

解説

Note: This connection property only applies when ConnectionType is set to Reports.

Every Workday entity is identified by a unique ID (generated by Workday) called a Workday ID (WID), but some types of entities have other types of identifiers.

For example, a Workday country record for the United States is identified using the "US" country code in addition to its WID.

By default, the 本製品 collects all these IDs under one column and produce an aggregate. For example, this is the value of the Country_Reference.ID column for the US record:

<wd:Country_Reference>
    <wd:ID type="WID">abcdef1234567890</wd:ID>
    <wd:ID type="Country_Code">US</wd:ID>
</wd:Country_Reference>

If this connection property is set to True, the 本製品 instead produces a separate column for each ID type. The aggregate value above is expanded into these two columns:

  • The column Country_Reference.ID.WID displays "abcdef1234567890"
  • The column Country_Reference.ID.Country_Code displays "US"

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