A comma-separated list of column types to exclude from query results.

Data Type

string

Default Value

""

Remarks

Several types of columns in Workday are slow to read or cause errors (see below) when they are queried.

Excluding these column types at the driver level allows for faster and more reliable queries without manually excluding these columns from every query.

If a column type is included in this property, it does not show up in table metadata and it cannot be used in queries.

This property can be set to a comma-separated list containing any combination of the following column types.

• Calculated Calculated columns require additional processing in Workday that can slows down queries. These columns typically start with a "cf_" prefix.
• MultiInstance Multi-instance columns are lists of IDs which refer to other Workday records. These lists can be large, which leads to slower queries because Workday must collect and format the entire list before returning it.
• Undefined Undefined columns are listed as being part of a WQL data source, but don't have a separate field definition. Querying undefined columns causes errors because Workday cannot find their metadata. Unfortunately, Workday's API does not provide a way for the driver to automatically determine whether a given column is undefined, so undefined columns must be manually excluded via this connection property.