ODBC Driver for Workday

Build 23.0.8839

WQLDataSourceFilters

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

Data Type

string

Default Value

""

Remarks

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 driver exposes one view per data source and determines the filter to use automatically. If the data source does not require a filter then the driver view queries the data source directly. Otherwise the driver 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 driver 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 23.0.8839