Specifies whether the OData service supports the $filter query parameter.

Data Type

bool

Default Value

true

Remarks

Set this property to true if your OData service supports filtering using the $filter query parameter.

When this property is set to true, the driver attempts to push filter logic to the OData service, reducing the volume of data retrieved and improving performance. However, the actual behavior depends on the capabilities of the OData service as some filter expressions may still be handled client-side if the service does not support them.

If your OData service does not support the $filter parameter, set this property to false. When this property is set to false, all requested data is retrieved from the service and filtered locally. This can significantly impact performance, so use this setting only when necessary.

For example, if $filter is not supported, the following query is processed client-side:

SELECT       * 
FROM         Categories_Products
WHERE        (Categories_CategoryID = 1)

This property is typically used with OData services that have partial or no support for filtering operations.