Excel Add-In for Workday

Build 24.0.9062

WQLDataSourceFilters

Determines what data source filters the provider uses when querying WQL data sources.

データ型

string

デフォルト値

""

解説

A WQL data source can have one or more data source filters. Each filter has its own set of prompts which determine the rows that are returned from the query. The fields included in each record are the same between filters.

The 本製品 exposes one view per data source and determines the filter to use automatically. If the data source does not require a filter then the 本製品 view queries the data source directly. Otherwise the 本製品 uses the first filter to the data source.

You can set this property to bypass this process for specific data sources. This property accepts a comma-separated list of dataSource=filter values. The data source is the WQL alias of the data source, while the filter is the WQL alias of the filter. These values are displayed on the View Data Source and View Data Source Filter screens respctively.

Note that the data source name is not always the same as the view name. If UseSplitTables is enabled, the 本製品 will make multiple views (journalLines_1, journalLines_2, ...) from the same data source (journalLines). All of these split views query the same data source.

For example, this value would make the journalLines view query the journalLinesFind filter, and the projectPortfolio view query the projectPortfolioDefaultFilter filter:

journalLines=journalLinesFind,projectPortfolio=projectPortfolioDefaultFilter

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