Excel Add-In for Microsoft Dynamics NAV

Build 24.0.9062

SupportsFilter

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 本製品 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 本製品 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 本製品 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)

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062