Set this to true if your OData service supports filters.

データ型

bool

デフォルト値

true

解説

This connection property is primarily used with limited OData APIs.

If your Microsoft Dynamics NAV service supports the $filter query parameter, set this to true. When set to true, the connector defers filter processing to the Microsoft Dynamics NAV service, which has a performance benefit. If you set this property to true when your Microsoft Dynamics NAV service does not support $filter, the connector returns "not supported" errors for queries containing filters.

If your Microsoft Dynamics NAV service does not support the $filter query parameter, set this to false. When set to false, the connector retrieves all of requested data for a given query from the Microsoft Dynamics NAV service before filtering it client-side. This is slower than deferring filters to the Microsoft Dynamics NAV service, so only set this property to false if $filter is unsupported on your service.

For example, if $filter is not supported, the following criteria is handled by the driver:

SELECT       * 
FROM         Categories_Products
WHERE        (Categories_CategoryID = 1)