Set this to true if your OData service supports filters.

Data Type

bool

Default Value

true

Remarks

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 add-in 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 add-in 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 add-in 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)