A comma-separated list of data sources paired with filters, used to override the default filter used by the provider when querying the specified 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 add-in exposes one view per data source and determines the filter to use automatically. If the data source does not require a filter, the add-in view queries the data source directly. Otherwise, the add-in uses the first filter for the data source.

You can use this connection 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, respectively.

Note that the data source name is not always the same as the view name. If UseSplitTables is enabled, the add-in makes 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 makes the journalLines view query the journalLinesFind filter, and the projectPortfolio view query the projectPortfolioDefaultFilter filter:

journalLines=journalLinesFind,projectPortfolio=projectPortfolioDefaultFilter