Set this to true if your OData service supports filters.

Syntax

Connect-DynamicsNAV -SupportsFilter bool

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 cmdlet 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 cmdlet 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 cmdlet 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)