Excel Add-In for Workday

Build 24.0.9062

DataSourcesDataSourceFiltersOptionalParameters

Reads /optionalParameters entries from the DataSourcesDataSourceFilters table.

Workday Resource Information

Retrieves the data source filter with the specified {ID} for a specific data source. You can only view data sources and data source filters that you have security access to.

Secured by: Development, WQL for Workday Extend, Workday Query Language+TG

Scope: System

Columns

Name Type Description
DataSourcesDataSourceFilters_Id [KEY] String The Workday ID of the DataSourcesDataSourceFilters that contains this.
DataSources_Id [KEY] String The Workday ID of the DataSources that owns this.
Alias String Supported for: SELECT. This field exposes WQL alias for Adhoc Query Enabled instances in WQL Rest APIs. This is for internal use only.
Description String Supported for: SELECT. Description for Query Parameter for External Promptable
Type String Supported for: SELECT. Returns "Text", "Date", "Numeric", "Currency", "Boolean", "Single Instance" or "Multi Instance".
WorkData_Descriptor String Supported for: SELECT. A description of the instance
WorkData_Href String Supported for: SELECT. A link to the instance
WorkData_Id String Supported for: SELECT. wid / id / reference id
Alias_Prompt String The alias of the data source filter.
SearchString_Prompt String The string to be searched in case insensitive manner within the descriptors of the data source filters.
Alias_Prompt_For_DataSources String Only used when a DataSources_Id filter is not provided. The alias of the data source.
SearchString_Prompt_For_DataSources String Only used when a DataSources_Id filter is not provided. The string to be searched in case insensitive manner within the descriptors of the data sources.

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